Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL : Can I use Select... Order By SUBSTR(xxxxx) ?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00251237
Message ID:
00251357
Vues:
5
>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?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform