What is the escape character for MS-SQL-Server

The backslash character will escape it, if you specify it as the escape character

WHERE field1 LIKE 'I\'m' ESCAPE '\'

I think doubling the single quotes makes it easier to read, but that isn't what you asked.