declare @IDS varchar(20),@PSORTS varchar(20),@sql VARCHAR(1000),@str varchar(10)
SELECT @IDS='55,44,10,13,15,90',@str='10'
select position=
len(@ids)-len(replace(@ids,',',''))+1 -
(len(stuff(@ids,1,charindex(','+@str+',',','+@ids+',')+1,'')) - len(replace(stuff(@ids,1,charindex(','+@str+',',','+@ids+',')+1,''),',','')))
--得出 '10'在 ids 字串变量中是第 3 个.