|Subject||Re: Calc field displays blank if 1 field is blank|
> > This SQL produces a blank if the first or last name is blank:I suppose that I do want to store an empty string instead of null. How
> > ((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?
do I accomplish that?