Subject Re: [firebird-support] String Concatenation with null field
Author Martijn Tonies
> 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
Upscene Productions
Database development questions? Check the forum!