Skip to main content

How to escape a single quote in SQL Server

Single quote issue is always irritating me and always I ignored this issue many times but in some scenario we can't. I searched this issue on google and found some solution and I want to share with you.

Suppose we have a string "I like codefari's article", we will escape the single quote here is the example.

SELECT 'I like codefari''s article' 

Please add a single quote at apostrophe s

Second example as given below

SELECT 'I like codefari'+CHAR(39)+'s article'

Here you can use CHAR(39) as given above example.