Hello All,

I have a query that returns the following results. We get multiple
rows back, with all the same info except for the Function.

ID NAME FUNCTION
001 Greg Johnson Administration
001 Greg Johnson Senior IT Specialist
002 Todd Thompson IT Specialist
002 Todd Thompson Project Manager


What shoudl I do to get the following result? Need to get Function
results for each contact within a single row, and separete them with
comma.

ID NAME FUNCTION
001 Greg Johnson Administration, Senior IT Specialist
002 Todd Thompson IT Specialist, Project Manager

Please, can anyone help?
Thanks!

Search this group with keyword "XMLGROUP".

Why do you wish to destroy First Normal Form (1NF) with a concatenated
list structure? Normal forms are the foundation of RDBMS, after
all.

Why are you formatting data in the back end? The basic principle of a
tiered architecture is that display is done in the front end and never
in the back end. This is a more basic programming principle than just
SQL and RDBMS.

Get a reporting tool so you can do a sort for your lists and lay them
out on paper or a screen in a way that a human being can read them.