Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert and hyphen
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01320326
Message ID:
01320348
Views:
11
>Sorry, Maybe I have not expressed myself well
>I used transform ( ) as you sugested and:
>
>test22 = TRANSFORM("1133412927", [@R 999-9999-9999])
>
>test22 results 113-341-2927
>
>and not 11-3341-2927 as I need
>
>Moises
>
>
>
>
>
>lcNumber = [1133412927]
>? TRANSFORM(lcNumber, [@R 999-9999-9999])
>lcNumber = [01133412927]
>? TRANSFORM(lcNumber, [@R 999-9999-9999])


Sorry, my mistake, Sergey gives you the right answer (as always :-)))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform