>Hey George,
>
>That is so absolutely perfect. I found 49 views that use a full join and there is no adhoc code. Jim Hou should look at this for a reason to go to 8.0.
>
>Thanks alot. I have the headache of updating 49 views, but at least I know I found them all.
>
>Thanks
>
Mitch,
First, you're welcome.
Second, sometimes we get so caught up with the major stuff, that we forget little gems like this one.
George
Ubi caritas et amor, deus ibi est