> Is there an equivalent for "SET CONCAT_NULL_YIELDS_NULL OFF" in FireBird? Because when I use field1 || field2 . If one of them is null, the result is null. I used a CASE WHEN ... END to correct that, but is there something like in SQL Server?

There isn't a (global) setting like in MSSQL. Either make sure that both
fields are initialized with an empty string when inserting a record, or
you could COALESCE as well.

SELECT
COALESCE(field1, '') || COALESCE(field2, '')
FROM
...



--
HTH,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2 (NEW!)
Upscene Productions
http://www.upscene.com