>
>? 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
uses this
Select Transform(Mytable.Phone,"@RB 99 99 99 99") As Phone from Mytable