Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Order by character vs numeric
Message
 
To
18/10/2009 06:14:30
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01429769
Message ID:
01429770
Views:
46
>Hi all,
>I need to order a cursor by a character field that contains numeric values (1,3,4,5,5bis,7..and so on). I cannot change the type of the field, but i want that number 5bis and 6 has a order before than 13. Some trick?
>Thanx
SELECT YourCursor
INDEX ON VAL(TheField) TAG YourCursor
BROWSE NORMAL
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform