>>Is this possible with a single SQL statement? If so, can someone please point me in the right direction.
>>
>>Thanks,
>
>I believe this is basically not possible - not with SQL alone - because that is not the way SQL works. Not even with several SELECT statements. You need a UDF that loops through each Drwno and creates the comma-delimited string. Once you have it, it is quite easy to add this as an additional (calculated) field. Make sure to CAST it to type memo.

Right, but it depends on the language. It is possible in SQL Server 2005 and up with simple statement and there is a request to create a concatenate function.

See http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/124023bd-4a3c-4f0a-8dbf-45cd3c16fc07