how to escape a character in sql code example

Example: escape-character-in-sql-server

To escape the character in SQL SERVER just put the single quotes
infront of the one that you're trying to escape.

e.g select 'it''s escaped'