MSSQL中Escape转义的使用
[sql]
IF OBJECT_ID('tempdb..#ABC') is not null
drop table tempdb..#ABC
www.2cto.com
create table #ABC
(
PATHNAME NVARCHAR(50)
)
insert into #ABC
SELECT N'/ABCDEFGHI'
UNION ALL SELECT N'/ABCDGAFGASASSDFA'
UNION ALL SELECT N'/ABCD'
UNION ALL SELECT N'/ABCD/'
UNION ALL SELECT N'/ABCD/JINJI'
UNION ALL SELECT N'XXXX/ABCD/JINJI/MMMNNNN'
----查看PATHNAME中包含/ABCD/的记录
SELECT * FROM #ABC
WHERE PATHNAME LIKE N'%//ABCD//%' escape '/'
查询结果
www.2cto.com
[sql]
PATHNAME
--------------------------------------------------
/ABCD/
/ABCD/JINJI
/ABCD/JINJI/MMMNNNN
XXXX/ABCD/JINJI/MMMNNNN
作者 wangxianshou