Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select statement diff lengths
Message
 
To
19/09/2008 14:37:23
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01349063
Message ID:
01349069
Views:
12
I AM using courier new, regular,9 in my command window whcih is where I do the SELECT. I think 18 chars is longest



>Do you use a proportional font? If so, try with "Courrier New".
>
>Does any of the fields have values bigger than 10 characters?
>
>>I thought padr would work but stuck with trying to have 3 cols aligned in:
>>select padr(name,10)+PADR(office,10)+PADR(phone,10) as name from bstkcust order by name
>>but it's misaligned.
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform