Hello all,
I want to retrive data from tblClient. I have fields trustid and Client name.

trustid ClientName
-------- ------------------
  1 John
  1 June
  2 Dave

I want above result to look like..

trustid ClientName
--------- --------------------
  1 John , June
  2 Dave

Is this possible?

Thanks for your help.

http://sqljunkies.com/WebLog/amachan...1/10/5065.aspx

--Jeff Moden

You can get this result. But there is no direct query for this. Read about cursors and use them. Or, use while loop in sql and temprary table.

try this

select trustid,COALESCE(ClientName) from tblClient group by trustid.

I hope it work.

__________________
Vikash Kumar Singh

Sorry Vikash, It wil not produce the desired result.