Hi Marcus,

> All,
> I have a computed field to put together the fullname of a person
> within a database table. The field is computed with
> (FIRST_NAME || ' ' || MIDDLE_NAME ' ' || SURNAME)
>
> But when I do a select on the field it is blank.
>
> An ideas?

If any of these fields IS NULL, the result will end up NULL too.


Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."