CHEERS FOR THE RESPONSE.. WORKED LIKE A DREAM.

I have been trying this solution out and it seems to be the answer to my problem.

Thanks very much for your help.

I would like to view it in separate columns or single comma delimited column.  For example in one row I would have Application name, Client 1 name, Client 2 name...

I can do it client side using  the application code but I would really like to build an sql statement so that users can also run the query.