sql server escape single quote

	DECLARE @text as NVARCHAR(400)
SET @text = 'I'm Still Studying.'
SELECT @text
	

			
	
			

		
	

The above code gives error Incorrect syntax near 'm'

Escaping the quote

Put an extra quote in front of that word. Now is recognized the whole thing as a text value like below.

sql escape single quote

	DECLARE @text as NVARCHAR(400)
SET @text = 'I''m Still Studying.'
SELECT @text
	

			
	
			

		
	

	I'm Still Studying.
	

			
	
			

		
	

• The doubling up of the quote should have worked.