Home Forums Programming General Sorting of 2 columns RE: Sorting of 2 columns

  • June 27, 2003 at 11:50 am

    #463523

    Actually, to produce the results:

    6 4

    6 2

    3 7

    2 3

    You actually want to sort by:

    64

    62

    37

    23

    so:

    Select * from Table

    order by cast(col1 as varchar) + cast(col2 as varchar) Desc

    Signature is NULL