>Why does this not work?
>
>The ZipZode field is C(10) and contains
> "12345-6789"
>
>I use
>
> cZipCode = TRANSFORM(Addresses.ZipCode, "99999-9999")
>
>And I get back:
>
> "12345-789"
>
>What am I doing wrong?
I am not sure, but I just did the following in the command window, and got back the correct values:
x = '12345-6789'
y = transform(x, '99999-9999')
? y && returns 12345-6789
I also tried it on a phone number field in one of my tables with a mask of 999-999-9999, and it returned the phone number properly. I am using VFP 6 SP3.
Mark McCasland
Midlothian, TX USA