Thanks , worked like a charm. 🙂

create table #emps (EN varchar(10))

insert into #emps values

('A'),

('B'),

('C'),

('D')

DECLARE @Names VARCHAR(8000)

SELECT @Names = COALESCE(@Names + ', ', '') + char(39)+en+char(39)

FROM #emps

print @Names

-- This query does'nt return any values when using...

Why doesn't this query return's any value . Whats wrong with this query

Select * from #emps Where EN IN (@Names)

Use of coalesce is not mandatory however the output has to be in the same format like 'A', 'B', 'C', 'D'

The above case is just a scenario , is there any possibility to get the desired output..? If how

Works like a charm... 🙂 Thanks mate

Haaa Haa , It was not a homework , I was just trying to implement a business scenario for sharing bills between room mates. The above query works like a...