> > 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?
>

I suppose that I do want to store an empty string instead of null. How
do I accomplish that?