I am passing a parameter to a dynamic sql string and have the parameter properly encompassed in
' marks to work in my dynamic sql. However, now I am needing to use the value in a diff location in my code, and want to remove all the
' marks. I tried the
Replace() function, but I must be using incorrect syntax as it still leaves the string with single quotes on each side. Take the sample DDL Below
DECLARE @Param1 nvarchar(500) = N'''Blue Bell Ice Cream'''; PRINT REPLACE(@Param1, '''''', '')
'Blue Bell Ice Cream'
My desired result to be returned is
Blue Bell Ice Cream
How should I write the
REPLACE() function in order to remove all single quotes?