Hi all,

please help me out here:

(adp + MSDE)

I have a very simple view:

select tableA.fieldA + ': ' + tableB.fieldB
from tableA Inner Join tableB On ...

When tableB.fieldB is Null, instead get "tableA.fieldA: ", I get nothing
even tableA,fieldA is not Null

I tested Select 'ABC' + ': ' + '' will get "ABC:"

but select 'ABC' + ': ' + NULL will get nothing

how to work arround this if I need to get "ABC:" if the 2nd part is Null

TIA

Jerry