select * from tb_table1 where ','+(cast(useridList as varchar(8000)) like '%,011,%' 如果这个字段的值不是非常巨大,可以试试上面这个转换
写多了一个'(' select * from tb_table1 where ','+cast(useridList as varchar(8000)) like '%,011,%'
select * from tb_table1 where ','+cast(useridList as varchar(8000))+',' like '%,011,%'
select * from tb where charindex(','+cast(useridList as varchar(8000))+',',',011,')>0
alter table tb_table1 alter column useridlist varchar(8000)
try select * from tb_table1 where ','+cast(useridList as varchar(8000)) like '%,011,%'
如果能确定useridlist字段的内容不会超过8000字符,那么可以先将useridlist转化为varchar类型后再检索。 select * from tb_table1 where ','+cast(useridList as varchar(8000))+',' like '%,011,%'
select * from tb_table1 where ','+cast(useridList as varchar(8000)) like '%,011,%'
select * from tb where ','+cast(useridList as varchar(8000)) like '%,011%'
select * from tb_table1 where ','+cast(useridList as varchar(8000)) like '%,011,%'
select * from tb_table1 where ','+cast(useridList as varchar(8000)) like '%011%'
select * from tb_table1 where ','+cast(useridList as varchar(8000)) like '%,011,%'
select * from tb_table1 where ','+cast(useridList as varchar(8000)) like '%,011,%'
select * from tb_table1 where ','+cast(useridList as varchar(8000))+',' like '%,011,%'