SQL query uses int to query the nvarchar field

If you use 2 to query a comma-delimited field with this ID data, you can use the database built-in function charindex to query the select * from the Users where CHARINDEX (', ' + ' 2 ' + ', ', ', ' +roleid+ ', ' >0 column is the loop to get the data field comma-delimited all the data into a string declare @i int
DECLARE @u int
declare @str nvarchar (max)
Set @i=1
Set @u= (SELECT COUNT (*) from Users)
Set @str = ';
While @i<[email protected]
Begin
Set @str + = (select Roleid from (select Row_number () over (order by ID) ' rowindex ', * from Users) hh where hh.rowindex = @i) + ' ,‘
Set @[email protected]+1
End
Set @str =substring (@str, 1,len (@str)-1)
Print @str
SELECT * from Dbo.fn_split1 (@str, ', ')
SELECT * from Users where CHARINDEX (' 2 ', Roleid) >0

SQL query uses int to query the nvarchar field