If the column is defined as not allowing nulls, then you can put an empty
string '' into the column.

I think you are confusing an empty string with a null column. An empty
string will give you the result you want.

Jerry Sands

> -----Original Message-----
> From: sentto-402930-8185-994114190-jsands=gofast.net@...
> [mailto:sentto-402930-8185-994114190-jsands=gofast.net@....c
> om]On Behalf Of max@...
> Sent: Monday, July 02, 2001 5:50 PM
> To: IBObjects@yahoogroups.com
> 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/
>
>
>