Focal Point
SORTING

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7431009331

September 29, 2005, 10:17 PM
MADDY
SORTING
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
GCohen
Possibly 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