sql server - Remove special character in sql -
replace(ab.firstname,', '')
how can remove character ' string in sql
you need double single quotes below
replace(ab.firstname, '''', '')
or
declare @name nvarchar(50) = 'ab''c' select replace(@name,'''', '')
Comments
Post a Comment