| Subject | Calc field displays blank if 1 field is blank |
|---|---|
| Author | ra8009 |
| Post date | 2004-08-02T18:29:44Z |
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?
((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?