Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Order By Clause in SELECT Query
Message
De
08/09/2006 15:27:49
Olaf Doschke
Setmics
Hamburg, Allemagne
 
 
À
08/09/2006 15:17:55
Tc Holzer
Isle of Man
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Re: Order By Clause in SELECT Query
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01152447
Message ID:
01152450
Vues:
17
This message has been marked as a message which has helped to the initial question of the thread.
Hi Tracy,

AFAIK ORDER BY does not support expressions, but field numbers are supported, so maybe put it:
SELECT PADL(Alltrim(number),8,'0') as cNumber, * .... ORDER BY ...,1

Bye, Olaf.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform