Combining two fields query

[#1]

Hi there,

I am combining two fields in my edit script as such:

Load

UserID & ' - ' & ContactPerson as Contact_Person_ID

From.....

However, if the UserID field or the ContactPerson field is empty it brings back a null value.

How would I edit this to make sure that either the UserId or the ContactPerson or both combined together will show up as the field "Contact_Person_ID"?

Thank you.

[#2]

Thank you all for assistance