[Firebird-test] String concatenation......

[Wilhelm T. <wi...@se...>]

Hi everybody!

I have this problem with string concatenation:

SELECT FIRST_NAME||LAST_NAME FROM CUSTOMERS

returns NULL when any of the fields has a NULL value.

Any ideas? I'm using FireBird 1.0

Thanks