? 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)
