> OK Martijn Tonies,
>
> But this is the unique form? My scripts will increase a lot in size with
> this.

Well, another way could be:

select <concatenate here>
from ...
where mycolumn is not null

union all

select <column with no concatenation>
from ...
where mycolumn is null



Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com