>How can I insert hyphens from right to left,
>one after the fourth digit and other after the eighth digit,
>so that the number: 1133412927 becomes 11-3341-2927
>
>Sometimes it can be: 01133412927, and must become: 011-3341-2927
>
>Thanks
>
>Moises
lcNumber = [1133412927]
? TRANSFORM(lcNumber, [@R 999-9999-9999])
lcNumber = [01133412927]
? TRANSFORM(lcNumber, [@R 999-9999-9999])
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.