求一条SQL语句，

[wxylvmnn]

有一个 限制表M，
表里就一个字段Mf存储的是
，
<
>
"
'等等一些特殊字符。

另有表A，有Af1，Af2，Af3，Af4这样4个字段。

能否通过一条sql语句，查出，在表A的Af2,Af3这2个字段中，是否包含限制表M里存储的特殊字符。

比如说表A有如下数据
Af1，Af2，Af3，Af4

123，>1,111,222
333,11,<22,323
555,1",<2',323
554,123,1232,323
553,123,1232,323
552,123,1232,323

希望得到
Af1，Af2，Af3，Af4

123，>1,111,222
333,11,<22,323
555,1",<2',323

[wxylvmnn]

哎，总是有这么多高手

[dawugui]

select a.* from a , m where
charindex(m.mf , a.af2) > 0
or
charindex(m.mf , a.af3) > 0

[dawugui]

create table M(mf varchar(10))
insert into m values(',')
insert into m values('<')
insert into m values('>')
insert into m values('"')
create table a(Af1 varchar(10),Af2 varchar(10),Af3 varchar(10),Af4 varchar(10))
insert into a values('123','>1' ,'111' ,'222')
insert into a values('333','11' ,'<22' ,'323')
insert into a values('555','1"' ,'<2''','323')
insert into a values('554','123','1232','323')
insert into a values('553','123','1232','323')
insert into a values('552','123','1232','323')
go


select a.* from a , m where 
charindex(m.mf , a.af2) > 0
or
charindex(m.mf , a.af3) > 0

drop table m, a

/*
Af1        Af2        Af3        Af4        
---------- ---------- ---------- ---------- 
333        11         <22        323
555        1"         <2'        323
123        >1         111        222
555        1"         <2'        323

（所影响的行数为 4 行）
*/

[dawugui]

create table M(mf varchar(10))
insert into m values(',')
insert into m values('<')
insert into m values('>')
insert into m values('"')
create table a(Af1 varchar(10),Af2 varchar(10),Af3 varchar(10),Af4 varchar(10))
insert into a values('123','>1' ,'111' ,'222')
insert into a values('333','11' ,'<22' ,'323')
insert into a values('555','1"' ,'<2''','323')
insert into a values('554','123','1232','323')
insert into a values('553','123','1232','323')
insert into a values('552','123','1232','323')
go


select distinct a.* from a , m where 
charindex(m.mf , a.af2) > 0
or
charindex(m.mf , a.af3) > 0

drop table m, a

/*
Af1        Af2        Af3        Af4        
---------- ---------- ---------- ---------- 
123        >1         111        222
333        11         <22        323
555        1"         <2'        323

（所影响的行数为 3 行）
*/

[叶子]

declare @m table (Mf varchar(1))
insert into @m
select '<' union all
select '>' union all
select '"'

declare @T table (Af1 int,Af2 varchar(3),Af3 varchar(4),Af4 int)
insert into @T
select 123,'>1','111',222 union all
select 333,'11','<22',323 union all
select 555,'1"','<2',323 union all
select 554,'123','1232',323 union all
select 553,'123','1232',323 union all
select 552,'123','1232',323

select * from @T t where
(select count(1) from @m where t.Af2 like '%'+Mf+'%'
or t.Af3 like '%'+Mf+'%')>0

/*
Af1         Af2  Af3  Af4
----------- ---- ---- -----------
123         >1   111  222
333         11   <22  323
555         1"   <2   323
*/