set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[TestList]
@UserID nvarchar(4000)
AS
DECLARE
@search_array nvarchar(100)
BEGIN
set @search_array ='16,17,18,19'
select * from Users where charindex(','+rtrim([User_ID])+',' , ','+ @UserID +',')>0
-- set @search_array= '''' + replace(@UserID,',',''',''') + '''';
-- Select * From Users Where [User_Name] in (@search_array);
END