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

[Martijn T. <m.t...@up...>]

> 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

My idea: as designed - and according to the SQL standard.

<something> + NULL = NULL
<something> || NULL = NULL


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."