62,046
社区成员
发帖
与我相关
我的任务
分享
select * from table where
replace(f_newgrade,' ','') like '%,3,%'
--可以的啊
declare @t table (name nvarchar(20))
insert into @t values( ',1,2,3,4,5')
insert into @t values ('1,2,4,5,6,' )
insert into @t values ( '1,2,3,4,5,6,7')
select * from @t where name like '%,3,%'
declare @tb table(f_newgrade varchar(200))
insert into @tb values(' ,1,2,3,4,5,6, ,3,4,5,6')
select * from @tb where f_newgrade like '%,3,%'
/*
f_newgrade
,1,2,3,4,5,6, ,3,4,5,6
*/