Tim ---

Try SET NULL ON and/or SET NULLDISPLAY TO "".

>
>SELECT ;
> MainCase.DAddress AS cByAddress, ;
> MainCase.DCity AS cByCity, ;
> MainCase.DState AS cByState, ;
> MainCase.DTaxID AS cByTaxID, ;
> MainCase.DZip AS cByZip ;
>FROM MainCase ;
>WHERE MainCase.Office + MainCase.CaseNo = ?gcOfficeCaseNumber ;
>UNION ALL ;
>SELECT ;
> Joint.JDAddr, ;
> Joint.JDCity, ;
> Joint.JDState, ;
> Joint.JDTaxID, ;
> Joint.JDZip ;
>FROM ;
> MainCase LEFT JOIN Joint ;
> ON Joint.Office + Joint.CaseNo = MainCase.Office + MainCase.CaseNo ;
>WHERE MainCase.Office + MainCase.CaseNo = ?gcOfficeCaseNumber