Re: Need Help with SQL Plus in 8i

what are you trying to do?
take a number (in a char column) like '(999) 999-9999' and make it into a number datatype of format 9999999999 or are you trying to take a number (in char column) like 9999999999 and make that into the formatted version of '(999) 999-9999'? You aren't going to be able to make your formatted number '(999) 999-9999' into a number datatype because of the dashes and brackets etc.

or are you trying to take whatever value is in the phone column and make it into that format (although it is still going to be in a char datatype)?

I'm confused --> my regular state of mind.

add a bit more detail for dummies like me, then I'll try to help you out.

;-)

Sergiu gp wrote:
>
> Hello guys, I am trying to perform a query on a table where there is a 'phone'
> column that has datatype char. I must convert it into a number and format it as
> follows: '(999) 999-9999' . I can't seem to find a way to do this correctly. I
> am using the command TO_NUMBER(phone, '(999) 999-9999'). I keep getting an
> illegal number format error. Can someone help?
>
> Thanks a bunch!
Received on Sun Feb 10 2002 - 20:17:14 CET