September 29, 2005, 10:17 PM
MADDYSORTING
Hello Friends,
i am using sql passthru to generate a report and in that i am changing the one integer field to char field using cast function.i am facing problems when i am trying to sort this field on focus side
that is if i am havig values like 1,2,3,7,12,13,24,33,44,77,n/a,unk,total after sorting that field its displaying them as 1,12,13,2,24,3,33,44,7,77,n/a,unk,total .is there any way so that we can display them in ascending order 1,2,3,7,12,13,24,33,44,77,n/a,unk,total ).
thanks
maddy
September 30, 2005, 12:31 AM
GCohenPossibly by adding a leading zero in front of a single integer before you convert it to alpha will make a sequence like.. 01 02 03 07 12 13 .
Or sort the data by the integer but with a NOPRINT option. e.g.
BY ORIGINAL NOPRINT BY CHANGED