The replace function with nvarchar(max) strings

Question

Hi Friends, I have an itemnumber field in my table i.e(114"CCALUM8'SHEETS) and the datatype is nvarchar(10) and it is having special charecters("",'). Can anyone give me the code to replace ("",') with empty space. I used replace function in sql as select replace('114"CCALUM8'SHEETS',''','') but i am getting error because uneven quotes in my itemnumber field. Please help me in this.

   Thanks.

Answer 1

0

Do you need this?

DECLARE @string NVARCHAR(MAX)
SELECT  @string = '114""CCALUM8''SHEETS'
SELECT  @string OriginalString, REPLACE(REPLACE(REPLACE(@string, '''', ''), '"', ''), ',', '') StringWithoutUnwantedChars

answered Aug 24 '12 at 11:07 AM

Usman Butt
13.8k ● 6 ● 8 ● 14

Thanks for the answer but here we are not using any param to store the itemnumber. we are directly fetching it from the table.

Aug 24 '12 at 12:02 PM sanjeev.matte

Just replace @String with the column name i guess.

Aug 24 '12 at 12:05 PM sp_lock

Yes..Its working..Thanks allot..

Aug 24 '12 at 12:08 PM sanjeev.matte

@sanjeev.matte Glad to know it helped. But can you please return us the favor by marking the answer as accepted? This will help the future users as well.

Aug 24 '12 at 12:14 PM Usman Butt

The answer is accepted..Thanks..

Aug 24 '12 at 12:44 PM sanjeev.matte

(comments are locked)

The replace function with nvarchar(max) strings

Follow this question

Related Questions