Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need idea for sort
Message
De
26/02/2010 06:15:21
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
À
26/02/2010 06:03:55
Thomas Ganss (En ligne)
Main Trend
Frankfurt, Allemagne
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01451160
Message ID:
01451183
Vues:
41
>try to get each word in a separate column in the select and order via SQL order by
>
>
>thomas

Thomas,

it's still a problem since its mixed alpha and digit. The digits should be sorted as numbers, the alphas as alphas after the digits.

As you can see in the message to Tore its a bit of PAD[L|R] to sort it out, but I need the lenght beforehand.


Agnes
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform