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)