select I from tablename where charindex(cast(A as char(3)),B)>0
搞错了: select * from tablename where charindex(cast(A as char(3)),B)>0
select * from tablename where charindex(','+(cast a as varchar)+',',','+b+',')>0
select * from tablename where CHARINDEX(A, B, 1) > 0
select * from tablename where CHARINDEX(cast(A as varchar(3)), B, 1) > 0
1. Len(B)<>Len(REPLACE(B,A,'')) 可以确定,条件是 A<>'' and A is not null 2. 自己写一个函数进行判断 Create funtion AinB(@A varchar,@B varchar) returns bit begin ... ... end;
select * from tablename where charindex(cast(A as char(3)),B)>0
2. 自己写一个函数进行判断
Create funtion AinB(@A varchar,@B varchar)
returns bit
begin
...
...
end;
select * from tablename where AinB(A,B)=1