How to seperate values with the help of Comma (,)
declare @strroles varchar(10)
declare @pos int
set @strroles = '1,2,3,4'; --Example Values
if substring(@strroles, LEN(@strroles)-1,0)<>','
set @strroles=@strroles+','
set @pos=0
declare @roleid as int
while charindex(',',@strroles)>0
begin
set @roleid = cast(substring (@strroles,0,charindex(',',@strroles))as int)
select @roleid
set @strroles= substring(@strroles, charindex (',',@strroles)+1, len(@strroles)-@pos)
END
Shashi Kant Ray