Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need idea for sort
Message
From
26/02/2010 09:31:27
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
26/02/2010 09:11:21
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01451160
Message ID:
01451228
Views:
35
>Hi Craig
>
>No ::(
>
>1.1
>1.10
>1.2
>1.2.R
>10.1

I don't see any other way but to split this into fields. Each field is a string, containing a character representation of a chunk which was originally between the dots...

select getwordnum(fld, 1, "."), getwordnum(fld,2, ".") ... order by 1,2,3,4

Now if you want 1.12 to sort after 1.2, you may need to left-pad the numbers to their maximal length.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform