查询[LIKE]SqlServer特殊字符
- WBOY原創
- 2016-06-07 15:40:271162瀏覽
http://www.dqhxz.com/Post_572.html 如 SELECT @EmailTitle = REPLACE(@EmailTitle,' [ ',' [[] ') --1 SELECT @EmailTitle = REPLACE(@EmailTitle,' % ',' [%] ') --2 SELECT @EmailTitle = REPLACE(@EmailTitle,' _ ',' [_] ') --3 SELECT @EmailTitle =
![查询[LIKE]SqlServer特殊字符](/inc/test.jsp?url=http%3A%2F%2Fimages.cnblogs.com%2Fcnblogs_com%2Fkkun%2FWindowsLiveWriter%2FLIKESqlServer_D38B%2Fimage_thumb_1.png&refer=http%3A%2F%2Fwww.cnblogs.com%2Fkkun%2Farchive%2F2010%2F08%2F19%2F1803521.html)
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
陳述：
本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn