Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inline formatting in SQL selects-more strange VFP behavi
Message
From
25/04/2001 23:10:28
 
 
To
25/04/2001 19:29:46
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00499921
Message ID:
00499967
Views:
22
>and the Line field is a left-justified char string of 1 or 2 chars, and I really want to sort by PADL(Line,2) for some reason issuing:
>
>SELECT PADL(Line,2) FROM SomeFile ORDER BY 1
>
>does NOT result in a properly sorted query.

Have you tried:
SELECT PADL(ALLTRIM(Line),2) FROM SomeFile ORDER BY 1
Sylvain Demers
Previous
Reply
Map
View

Click here to load this message in the networking platform