Escape Character in SQL Server

Question

I want to use an escape character with a quotation. How can I prevent the following error when a special character is present?

Unclosed quotation mark after the character string.

Answer 1

You can escape quotation like this:

select 'it''s escaped'

Result will be:

it's escaped