Posted by simonshang on 07/18/07 17:56

Hi, all friends. I'm using SQL-SERVER 2000.I have a table like this:
NIF Name
----------------------------------------
A-1234 Company1
B-123-B1 Company2
C-4568 Company4
D-453-DF Company5

I want delete the symbol "-" in the row "NIF". eg. A-1234 change to
A1234, D-453-DF to D453DF

So how can I write the sentence . Should I use the Stored Procedure?
Thank you very much!!
Simon

• Next in forum: Re: Combining many records into 1
• Prev in forum: sessions being killed by sa updating stats?
• Thread view: How write this sentence with T-SQL

[Reply to this message]