I have the following SQL Statement:

VB Code:
  1. SELECT VEN.VENNUM, (VEN.TITLE + ' ' + VEN.FNAM + ' ' + VEN.LNAM) AS PERSON ...

When any of the fields inside of the PERSON Field are Null it returns a Null. How can I prevent this?