eQL for Files.Name, returning one row per document where multiple files

Hi Bentley and the Forum,

I have a report that brings back the files on a set of documents. That works fine but where there are multiple files, it brings back 2 rows. I would ideally like one row per document with the Files.Name column concatenated with the names of the files with a comma or pipe or something. Can this be done in eQL at all? If so, how about SQL? I have been trying with COALESCE but no luck yet.

Many thanks,


   Code LIKE 'SAA3A%'
   AND IsLatestRevision = 'Y'