declare @typeid varchar(10) set @typeid='5'select * from member where charindex(','+@typeid+',', ','+typeid+',') > 0
if object_id('Member') is not null drop table Member go create table Member(typeid varchar(50)) insert into Member select '3,5,7,9,12,'declare @typeid varchar(50) set @typeid='5' select * from member where charindex(','+@typeid+',',','+typeid)>03,5,7,9,12,如果后面没有12,,那就上语句的','+typeid+','后面这,也加上
if object_id('Member') is not null drop table Member go create table Member(typeid varchar(50)) insert into Member select '3,5,7,9,12' --这没,号declare @typeid varchar(50) set @typeid='5' select * from member where charindex(','+@typeid+',',','+typeid+',')>0--这加','
我去试下~谢谢 wzy_love_sly
我存的格式是有那个“,” 就是 这样的格式 3,5,7,9,12, 写成这样的吧应该 select * from member where charindex(','+@typeid+',',','+typeid)>0
set @typeid='5'select * from member where charindex(','+@typeid+',', ','+typeid+',') > 0
drop table Member
go
create table Member(typeid varchar(50))
insert into Member select '3,5,7,9,12,'declare @typeid varchar(50)
set @typeid='5'
select * from member where charindex(','+@typeid+',',','+typeid)>03,5,7,9,12,如果后面没有12,,那就上语句的','+typeid+','后面这,也加上
drop table Member
go
create table Member(typeid varchar(50))
insert into Member select '3,5,7,9,12' --这没,号declare @typeid varchar(50)
set @typeid='5'
select * from member where charindex(','+@typeid+',',','+typeid+',')>0--这加','
写成这样的吧应该
select * from member where charindex(','+@typeid+',',','+typeid)>0