Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select Transform(phone,
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01019262
Message ID:
01019270
Views:
25
Yes, that works, but I do wonder why?

If I'm not much mistaken it's 5 in the morning your place. Whatever are you doing in front of a computer at this hour?

Anyway, thank's!

BR

Peter

>Try this:
>
>Select Padr(Transform(Mytable.Phone,"@R 99 99 99 99"), 11, " ") As Phone from Mytable
>
>
>>
>>? Transform(38109945,"@R 99 99 99 99")
>>
>>
>>Returns 38 10 99 45, as expected.
>>
>>But:
>>
>>
>>Select Transform(Mytable.Phone,"@R 99 99 99 99") As Phone from Mytable
>>
>>
>>Returns 38 10, which is certainly not what I expected.
>>
>>I assume it's a valid expression, since VFP does not complain, but I'm clearly stretching it's capabilities.
>>
>>TIA
Peter Pirker


Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?

(Woody Allen)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform