关于 In()

Question

create procedure p
@str varchar(8000)
asselect * from 表 where charindex(','+字段+',',','+@str+',')>0go

Answer 1

declare @FirstList varchar(8000)
declare @CurList varchar(8000)
declare @LastList varchar(8000)
set @FirstList= 'A,B,C,D'+','
set @LastList=''
while len(@FirstList)>0
begin
     set @CurList =SUBSTRING(@FirstList,1,CHARINDEX(',',@FirstList,1)-1)
     set @FirstList=SUBSTRING(@FirstList,CHARINDEX(',',@FirstList,1)+1,len(@FirstList))
     set @LastList=@LastList+''''+@CurList+''''+','
end
set @LastList=left(@LastList,len(@LastList)-1)
set @LastList='('+@LastList+')'
print @LastList