Subject Re: [firebird-support] Calc field displays blank if 1 field is blank
Author Martijn Tonies

> 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
Upscene Productions