Post reply

I need to provide sort option on the first two positions of a field(

  • October 28, 2010 at 12:29 pm

    #230962

    Hi frnds,

    I need to provide sort option on the first two positions of a field(Ex:user wants to sort only two positions of 1200,2300).in this case it is on 12 an 13.its char(4) field and the field is in group.

    plase let me know,urgent,

    dhari

  • October 28, 2010 at 3:34 pm

    #1243883

    So they don't care if the rest of the number is random?

    1234

    1243

    1299

    1257

    1201

    What is the point? Why not just sort by the whole field?

    1204

    1234

    1243

    1257

    1299

    It is still the same data, and it is easier to read and find what you want.

    I guess I don't understand why sorting the entire column won't work.

  • October 28, 2010 at 5:00 pm

    #1243926

    order by left(MyColumn,2)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply