SET VAR vphone TEXT = '8001234567'
SET VAR vptest TEXT = (FORMAT(.vphone, '(%%%)^%%%-%%%%'))
Then vptest = (800)^123-4567
I don't know how to insert a space in the string using a simple FORMAT command.
_______________________________________
At 04:32 PM 4/20/2001 -0500, you wrote:
>AHA! the light dawns. You need the ^ space holder in the format
>
>(%%%)^%%%-%%%
>
>
>
>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
>Behalf Of Bernie Corrigan
>Sent: Friday, April 20, 2001 4:48 PM
>To: [EMAIL PROTECTED]
>Subject: Re: Formatting a column
>
>
>At 07:07 PM 4/19/2001 -0700, you wrote:
>>(FORMAT(columname,'(%%%) %%%-%%%%))
>
>Doesn't work. This will result in an error condition.
>
>It needs to be: (FORMAT(columname,'(%%%) %%%-%%%%'))
>
>Also, say we start with a value of 8001234567
>
>then leaving the space in the FORMAT argument results in (800)1234-567
>
>FORMAT(columname,'(%%%)%%%-%%%%')) results in (800)123-4567
>
>
>
