declare @tb table(Num varchar(5)) insert into @tb select '1' insert into @tb select '2' insert into @tb select '3' insert into @tb select '4' insert into @tb select '5' insert into @tb select '6' insert into @tb select '7' insert into @tb select '8' insert into @tb select '9' insert into @tb select '10'declare @c varchar(8000) set @c ='1,3,2,5,8,4,9' Select Num From @tb Where @c= '' or @c is Null or Charindex(','+Ltrim(Num)+',',','+Isnull(@c,'')+',')>0 order by Charindex(','+Ltrim(Num)+',',','+Isnull(@c,'')+',')1 3 2 5 8 4 9
declare @c varchar(8000) set @c ='1,3,2,5,8,4,9' Select ID, Num, Name From tablea Where @c= '' or @c is Null or Charindex(','+Ltrim(Num)+',',','+Isnull(@c,'')+',')>0 order by Charindex(','+Ltrim(Num)+',',','+Isnull(@c,'')+',')
declare @c varchar(8000) set @c ='1,3,2,5,8,4,9' declare @w xml set @c ='1,3,2,5,8,4,9' set @c =replace('<b><a>1,3,2,5,8,4,9</a></b>',',','</a><a>') set @w=@cSELECT T.c.value('.','int') as ID FROM @w.nodes('/b/a') T(c)
insert into @tb select '1'
insert into @tb select '2'
insert into @tb select '3'
insert into @tb select '4'
insert into @tb select '5'
insert into @tb select '6'
insert into @tb select '7'
insert into @tb select '8'
insert into @tb select '9'
insert into @tb select '10'declare @c varchar(8000)
set @c ='1,3,2,5,8,4,9'
Select
Num
From @tb
Where @c= ''
or @c is Null
or Charindex(','+Ltrim(Num)+',',','+Isnull(@c,'')+',')>0
order by Charindex(','+Ltrim(Num)+',',','+Isnull(@c,'')+',')1
3
2
5
8
4
9
set @c ='1,3,2,5,8,4,9'
Select ID,
Num,
Name
From tablea
Where @c= ''
or @c is Null
or Charindex(','+Ltrim(Num)+',',','+Isnull(@c,'')+',')>0
order by Charindex(','+Ltrim(Num)+',',','+Isnull(@c,'')+',')
set @c ='1,3,2,5,8,4,9'
declare @w xml
set @c ='1,3,2,5,8,4,9'
set @c =replace('<b><a>1,3,2,5,8,4,9</a></b>',',','</a><a>')
set @w=@cSELECT T.c.value('.','int') as ID
FROM @w.nodes('/b/a') T(c)