Use a SP to test for a NULL value and return the adequate value.

Luiz.

----- Original Message -----
From: <max@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, July 02, 2001 7:49 PM
Subject: Re: [IBO] Concatenate strings in result sets


> Is there any way to work around getting a NULL for the result set if
> FirstName is NULL? The only thing I can think of is inserting a
> blank (' ') in the FirstName Field. Is there a more elegant solution?
>
> Maxie
>
> --- In IBObjects@y..., "Thomas Steinmaurer" <thomas.steinmaurer@a...>
> wrote:
> > Try:
> >
> > Select (FirstName || " " || LastName) As FullName from Person
> >
> > But be aware that the whole expression is NULL when FirstName or
> LastName is
> > NULL
> >
> > Thomas
> >
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>