Post reply

Order a numeric field

  • February 13, 2007 at 5:07 am

    #116124

    Hi Guys,

    Is there a was I can order a numberic field numerically?

    For example

    14

    76

    95

    99

    117

    131

    Instead of

    117

    131

    14

    76

    95

    99

    Thanks

  • February 13, 2007 at 5:09 am

    #689410

    Select <FieldName>

    FROM

    <TableName>

    ORDER BY

    <FieldName> ASC

     

    Prasad Bhogadi
    www.inforaise.com

  • February 13, 2007 at 5:13 am

    #689413

    Sorry for some reason the field was a varchar field which only contains numbers which is why the sort order was incorrect.

    I will cast it as an int to sort this out.

  • February 13, 2007 at 5:16 am

    #689414

    I assumed so that it could be a VARCHAR, makes sense to change the datatype to desired format unless you really forsee a condition where it has potential need to save VARCHAR DATA.

     

    Prasad Bhogadi
    www.inforaise.com

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

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