Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need idea for sort
Message
From
26/02/2010 06:18:19
Thomas Ganss (Online)
Main Trend
Frankfurt, Germany
 
 
To
26/02/2010 06:10:17
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01451160
Message ID:
01451184
Views:
46
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
Map
View

Click here to load this message in the networking platform