>I'm getting a cursor full of data from a SQL Server table, I need to order the data based on a decimal field I receive.
>
>

>  Select * from curSQLData order by LayoutValue into cursor curFillData
>

>
>Sample data from Current query:
>

>4.1000
>4.1100
>4.2000
>

>
>I need to get it to order like:
>
>

>4.1000
>4.2000
>4.1100
>

If I got you right, you want the right zeros stripped from the decimals, and then to convert to integers... I see no easy way to do that on SQL side, but when you get the data down, let's assume that you've added another column fldSort n(10,4):

scan
   lcStr=substr(str(LayoutValue), at(".", str(LayoutValue))+1)+" "
   do while "0 "$lcStr
      lcStr=strtran(lcStr, "0 ", " ")
   enddo
   replace fldSort with int(LayoutValue)+val(lcStr)/10000
endscan

Then index on fldSort, or Select * ... order FldSort