hi
just execute the query in sql server..this will give you an idea about comma seperation.
declare @roleIds varchar(250),
@userId int
BEGIN
set @roleIds='1,2,3,4,5,6,7,'
DECLARE @sItem VARCHAR(8000)
While (Charindex(',',@roleIds)>0)
Begin
Select @sItem = ltrim(rtrim(Substring(@roleIds,1,Charindex(',',@roleIds)-1)))
Set @roleIds = Substring(@roleIds,Charindex(',',@roleIds)+1,len(@roleIds))
declare @n int
SET @n = CONVERT(int, @sItem)
print @n
End
END
I hope this may help you....