The not so nice part will be ordering 20 and 20DP, something like
Str(evl(int(Val(field)), 9999999999), 20) + PADR(iif(int(Val(field))=0, Alltrim(Field), StrTran(Alltrim(Field), Alltrim(Str(Val(field), 20)), "", 1), 20))
and betcha there will be further fringe cases as the not handled leading zero ;-)
thomas
>We clearly think alike! :-)
>
>>try to get each word in a separate column in the select and order via SQL order by
>>
>>
>>thomas
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only