Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inline formatting in SQL selects-more strange VFP behavi
Message
From
27/04/2001 01:25:08
Arne Hermann
Synercom/edi
Vancouver, British Columbia, Canada
 
 
To
26/04/2001 06:22:06
Daniel Gramunt
Nokia
Lausanne, Switzerland
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Inline formatting in SQL selects-more strange VFP behavi
Miscellaneous
Thread ID:
00499921
Message ID:
00500527
Views:
22
Daniel,

(Also: thanks, Sylvain)

>Try:
>

>SELE PADR(ALLTRIM(line),2) FROM somefile ORDER BY 1

Of course you mean PADL :)

Thanks, that did work, but I can't quite figure out why.  Why is this any different from just PADL(Line,2)?

-Arne


arne@synercom-edi.com "There are no absolutes but this one."
President, synercom/edi - Event Ticketing Solutions
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform