escape.sql

本程序中即有讲义

create table t1
(
c1 int,
c2 char(10)
)
go

insert into t1 values(1,'冰箱A_100')
insert into t1 values(2,'冰箱A_200')
insert into t1 values(3,'冰箱B_200')
insert into t1 values(4,'冰箱A_%%')
go
select * from t1 
select * from t1 where c2 like '%冰箱_A%%' escape '_'
select * from t1 where c2 like '%冰箱A%%' escape '_'
select * from t1 where c2 like '%冰箱A_%' escape '_'
select * from t1 where c2 like '%冰箱A%' escape '_'
select * from t1 where c2 like '%冰箱A%_%' escape '_'