I am running the select query below. the problem is that when I join tblContact.strLName + ',' + tblContact.strFName + '-' + tblContact.strTitle AS name I get a null value is either strlname, strfname or strtitle is Null. How can I write it so that if one of the values isnull it still writes out the name. Thank you
SELECT DISTINCT
tblContact.lngContactId, tblContact.strLName, tblContact.strFName, tblContact.strTitle,
tblContact.strLName + ',' + tblContact.strFName + '-' + tblContact.strTitle AS name
FROM tblContactType INNER JOIN
tblContact INNER JOIN
tblContactClass ON tblContact.lngContactId = tblContactClass.lngContact
Id ON tblContactType.lngContactT
ype = tblContactClass.lngContact
Type
WHERE (tblContact.strLName IS NOT NULL)
ORDER BY tblContact.strLName DESC, tblContact.lngContactId
Start Free Trial