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
