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
>