Declare @condition Varchar(1000) Declare @Where Varchar(1000) If @condition='1' Or @condition='2' Set @Where='where parameter='+@condition Else If @condition='1,2' Set @Where='where parameter=1 or parameter=2'
declare @condition varchar(50) set @condition='1,2,3' select @condition='parameter='+replace(@condition,',',' or parameter=')exec('select * from yourtable where '+ @condition)
set @condition='1,2,3'
select @condition='parameter='+replace(@condition,',',' or parameter=')exec('select * from yourtable where '+ @condition)