I've just read this in r4403:
MSSQL wants single quotes escaped with a second single quote, not with a backslash. No clue how to escape joker chars in a WHERE clause.
Not sure if you referred to the ESCAPE clause:
The default separator varies between different DBMS but the ESCAPE clause works the same way in MySQL and SQL Server (or even in Oracle).
I admit I was sceptical about the whole SQL Server feature but I'm actually using HeidiSQL with SQL Server 2005 for a project this week so I might report some issues if I find them.
MSSQL: Escape joker chars in conjunction with an "ESCAPE" appendix after the LIKE clause. See http://www.heidisql.com/forum.php?t=12747 .
However, nailed in r4404.
Please login to leave a reply, or register at first.