Hi,

> This SQL produces a blank if the first or last name is blank:
>
> ((Last_Name||', ')||First_Name)
>
> How can I write it so it will display just the last name or first name
> if the other name is blank?

I assume you mean "if the other name is NULL", right?

There's an easy workaround by using COALESCE.

The question is, however: why are you storing NULL?
Do you want to store NULL or an empty string?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com