如何为SQL LIKE在用户输入中转义特殊字符？

@query

DECLARE @query varchar(100)
SET @query = \'less than 1% fat\'

CREATE TABLE X ([A] VARCHAR(100))
INSERT X VALUES (\'less than 1% fat\')
INSERT X VALUES (\'less than 1% of doctors recommend this - it\'\'s full of fat!\')
SELECT * FROM X WHERE A LIKE \'%\' + @query + \'%\'
DROP TABLE X

\'less than 1% fat\'

less than 1% fat
less than 1% of doctors recommend this - it\'s full of fat!

@query

\'less than 1[%] fat\'

SELECT c1 
FROM mytbl2
WHERE c1 LIKE \'%10-15!% off%\' ESCAPE \'!\';