I am working on a personnel directory for the school district were I work. I included the ability to do searches in ASP. The information is pulled from a SQL database. One of the fields the search returns is the building were they work. In the database, teachers that work in multiple buildings have multiple records in the database-- a record for each building they work in. These people are displayed multiple times in the search.
Example:
Joe Smith - Building A
Joe Smith - Building B

I would like to do something so the results are as follows:
Joe Smith - Building A, Building B

Any idea how I can do this :confused: ? Any help is appreciated.