Escape Sequences in MSSQL

User can escape single quote using two single quotes (NOT double quote).
e.g. SELECT 'Hi, My Name''s Steve.'
will result:
 Hi, My Name's Steve.