Unbound field w/ 2 values is blank when 1 is null. 1

[qwert231]

I have an unbound field with 2 fields combined with a , in between. But if the firstname field is blank, I get nothing in the field, even though the lastname contains a value.
Here is my field's formula:
{viewSubjInfUC.LastName} & ", " & {viewSubjInfUC.FirstName}

I want the field to show whatever data is available, regardless of whether or not one field is null or not.

I am using a .Net DataSet.

Any ideas?

 

[vidru]

I usually do something like this for names:

IF isnull({viewSubjInfUC.LastName}) or {viewSubjInfUC.LastName} = '' then
{viewSubjInfUC.FirstName}
else if isnull({viewSubjInfUC.FirstName} or {viewSubjInfUC.FirstName} = '' then
{viewSubjInfUC.LastName}
else
{viewSubjInfUC.LastName} & ', ' & {viewSubjInfUC.FirstName}

-dave