Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL : Can I use Select... Order By SUBSTR(xxxxx) ?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00251237
Message ID:
00251357
Views:
4
>I guess your tip will help. I'll put an extra field in my cursor as,
>
>SELECT substr(month,5,2)+substr(year,4,2) AS mysort FROM.... ORDER BY mysort
>
>since it can kill 2 birds with one stone, as how Ed stated.

If you're going to put an extra field in, why don't you use the full date? That way, you don't have any Y2K issues on the sorting.
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform