>
Huh? How can this be when I have a PADR(...50) around that field? And why would removing the last four outer joins, which have nothing to do with the CustPartNo field fix this problem?
>
> PADR(NVL(Parts.PartName,DXFParts.DXFName),50) as CustPartNo, ;
> >
> Just a SWAG here - what happens if DXFParts.DXFName is null?
>
>
Regards,
> Marcia G. Akins
> Tightline Computers, Inc.That was it! But just out of curiosity, would you have any idea why removing the last few outer joins got rid of the problem? I was still joining to Parts and DXFParts.
-BP
www.peisch.com