I have the following SQL Statement:
VB Code:
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?
|
Results 1 to 6 of 6
Thread: [RESOLVED] Concating Null ValuesThreaded View
|
Click Here to Expand Forum to Full Width |