Replace single quotes in SQL Server

user_168706 0
Viewed 343651

I have this function in SQL Server to replace single quotes.

But when I insert a single quote it throws an error on Replace(@strip,''','')):

Create Function [dbo].[fn_stripsingleQuote]
    (@strStrip varchar(Max))
    returns varchar
as
begin
    declare @CleanString varchar(Max)
    SET @var=(Replace(@strip,'',''))

    return @var
end
error-handling sql-server replace
14 Answers

We have to double the number of quotes.

To replace single quote :

REPLACE(@strip, '''', '')

To replace double quotes :

REPLACE(@strip, '''''', '')
user_81940890

Try this :

select replace (colname, char(39)+char(39), '') AS colname FROM .[dbo].[Db Name];

I have achieved the desired result. Example : Input value --> Like '%Pat') '' OR 

      Want Output -->  *Like '%Pat') OR*

using above query achieved the desired result.

user_14745880

select replace ( colname, '''', '') AS colname FROM .[dbo].[Db Name]

user_90373430
Related