Replace single quotes in SQL Server

Question

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 

Answer 1

You need to double up your single quotes as follows:

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

Answer 2

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

SQL uses two quotes to represent one in a string.