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

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

Hi Wilhelm,

> Thanks for your quick response.

(perhaps it's better to take this to mailto:ib-...@ya...)
 
> I can agree with you, but there are any workarounds?
> I don't want the result to be NULL but the value of not null field....

Anyway, if you don't want a NULL result, why are you storing
NULL in the column? I mean, if it's an "unknown" value, you will
get an "unknown" result - if you want an "empty" ( = "") value,
store empty instead of 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."