>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
Rick Borup, MCSD
recursion (rE-kur'-shun) n.
see recursion.