declare @array nvarchar(100)
set @array='5,100,23,25,7'
select customer_id,customer_name,remarks
from customers
where ','+@array+',' like '%,'+convert(nvarchar(100),customer_id)+',%'
declare @array nvarchar(100)
set @array='5,100,23,25,7'
select customer_id,customer_name,remarks
from customers
where ','+@array+',' like '%,'+convert(nvarchar(100),customer_id)+',%'