>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.

Michael,

Garrett Fitzgerald pointed out a Knowledge Base article on this topic just last week. Take a look at http://support.microsoft.com/support/kb/articles/q268/9/06.asp

-Rick