Using comma separated values in SQL
we can use comma separated values as input in sql. For this we should use some xml queries. Use the below query. declare @emp_id varchar(6000) set @emp_id ='clkl23,kjlj90,89kjm,88474ur,' select distinct employeename from employee where emp_id in( SELECT t.c.value('.', 'VARCHAR(6000)') FROM ( SELECT x = CAST('<t>' + REPLACE(@emp_id, ',', '</t><t>') + '</t>' AS XML) ) a CROSS APPLY x.nodes('/t') t(c) )