Subject Re: [ib-support] string concatination, triggers
Author Helen Borrie
At 11:08 AM 09-04-01 +0200, you wrote:
>Helen,
>
> > >If I define a computed column like the one in documents:
> > >full_name computed by (first_name || ' ' || last_name)
> > >It works only if non of the two composing columns is null. Otherwise, the
> > >value is null if any of the two is null.
> >
> > Correct. Value + NULL evaluates to false.
>
>As a matter of fact, Value + NULL evaluates to NULL.
>I guess you meant that.

No, I meant what I said.

Helen


All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________