What is the escape character for MS-SQL-Server
WHERE field1 LIKE 'I'm'
Note the middle quotation is invalid, what is SQL's literal character, like / in C#
Use double ' to escape it in SQL-Server
WHERE field1 LIKE 'I''m'
In other DB engines like MySQL using backslash works too
WHERE field1 LIKE 'I\'m'
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments