...@list = right(@list, len(@list) - charindex(@delim,
@list))
end
if len(@list) > 0
insert into @listTable(Position, Value)
values(@myPos, @list)
RETURN
END
And I will call it like:
SELECT *
FROM testtable
WHERE (sectionID IN (
Select value from dbo.listToTable(@sectionID, ',')
))