Subject | Re: [ib-support] string concatination, triggers |
---|---|
Author | Helen Borrie |
Post date | 2001-04-09T11:52:04Z |
At 11:08 AM 09-04-01 +0200, you wrote:
Helen
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________
>Helen,No, I meant what I said.
>
> > >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.
Helen
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________