>Is there anyway to prevent ".null." from populating a field when an outer join is done and no match is found in the child table? I already have SET NULL OFF.
See the NVL() function.
Ex:
SELECT NVL(MyField, My_Default_Value) AS MyField, ....
Luis María Guayán
Tucumán, Argentina
________________________________
SysOp de
www.PortalFox.comNada corre como un zorro
________________________________