Hi,

At June 9, 2005, 15:26, mona yazbeck wrote:

> Is there an equivalent for "SET CONCAT_NULL_YIELDS_NULL OFF" in FireBird? 

No.

> Because when I use field1 || field2 . If one of them is null, the result is null. 

As per the SQL Standard.

> I used a CASE WHEN ... END to correct that, but is there something like in SQL Server?

You can use CASE WHEN ... END, and the other alternative is to use
COALESCE.

Here's an example on how to use COALESCE:
COALESCE(field1, '') || COALESCE(field2, '')



--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Consultants Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)