Re: [SQL] append columns that are null

I'd be out of work very soon :( nobody wrote: You are welcome. Only if all problems were that simple ;-)... "Gerwin Philippo" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] THX! didn't know that one yet :) nobody wrote: "Gerwin Philippo" <[

[SQL] append columns that are null

I have function that appends 2 columns, like "new.field1 = new.field2||new.field3", but when field 3 is null, then the entire outcome is null, while I expected just field2, since when I append nothing to field2, I get field2, right? Is this standard behaviour, and if so, is there another append f

Re: [SQL] append columns that are null

THX! didn't know that one yet :) nobody wrote: "Gerwin Philippo" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] I have function that appends 2 columns, like "new.field1 = new.field2||new.field3", but when field 3 is null, then the entire outcome is nul