Skip to Content
0
Former Member
May 25, 2016 at 11:39 AM

Combine of names

40 Views

I have customer table that has a column for the customer_name.

It can be blank. If it's blank, I can get the name from 2 columns as well, called firstname and lastname.

How can I combine these two to display with blank?

So that my formula would look like:

If Customer_Name > ' ' then Customer_Name else

Firstname + ' ' Lastname