Tops on my SQL wish list would be a GROUP BY function that would concatenate string fields - like a SUM() function sums up numeric values in the group, this new function would string together character values in the group using a specified delimiter character. I've needed something like this for years, but have had to created a stored procedure loop to do this. This may be what GPO noted previously. Please make this happen.