Home » RDBMS Server » Server Administration » SQL
SQL [message #373461] Wed, 18 April 2001 10:08 Go to next message
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 .
How do I do that .
Any help is apprecitaed.

Thanks,
Aish

Report message to a moderator

Re: SQL [message #373489 is a reply to message #373461] Thu, 19 April 2001 04:12 Go to previous message
Thirumalai and Prakash
Messages: 23
Registered: March 2001
Junior Member
Hi Ash,

Use this,

UPDATE tablename SET ssn=replace(ssn,'-');

Regards
S.Thirumalai

Report message to a moderator

Previous Topic: prime number
Next Topic: ACCESS UPDATE != Oracle UPDATE ????
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 00:44:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.