查询[LIKE]SqlServer特殊字符

image

转载自:http://www.dqhxz.com/Post_572.html


SELECT @EmailTitle = REPLACE(@EmailTitle,'[','[[]')--1
SELECT @EmailTitle = REPLACE(@EmailTitle,'%','[%]')--2
SELECT @EmailTitle = REPLACE(@EmailTitle,'_','[_]')--3
SELECT @EmailTitle = REPLACE(@EmailTitle,'^','[^]')--4

原文地址:https://www.cnblogs.com/kkun/p/1803521.html