You can also use SET NULLDISPLAY to change the NULLs to blank ro whatever.
As an aside, Bret, .NULL. is the proper return value in JOINs. Blank is not valid, as there may be a joined blank. See? Jim Booth could explain this better.
>>Bret,
>>
>>You can use NVL() to return a blank, 0, or .F. where your LEFT JOIN returns nulls.
>
>Thanks I will try that
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
