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