OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » SQL

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL [message #373462]

Wed, 18 April 2001 10:09

aish74
Messages: 19
Registered: March 2001

Junior Member

Hi,

I have a col SSN in a table which has data in the format
999-99-9999 I want to remove the "-" from it .So the data should look like 999999999
How do I do that .
Any help is apprecitaed.

Thanks,
Aish

Report message to a moderator

Re: SQL [message #373467 is a reply to message #373462]

Wed, 18 April 2001 11:47

Raj.C
Messages: 7
Registered: April 2001

Junior Member

Answer to your question.

SQL> select replace('999-99-9999','-') SSN from dual;

SSN
---------
999999999

-Thanks
-Raj

Report message to a moderator

Re: SQL [message #373469 is a reply to message #373462]

Wed, 18 April 2001 11:50

aish
Messages: 44
Registered: March 2001

Member

Thanks Raj.

Report message to a moderator

Previous Topic:	Re: how to delet a view from database
Next Topic:	Re: how to delet a view from database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 02:35:18 CDT 2024