Arthur Fuller
fuller.artful at gmail.com
Tue Mar 17 13:02:16 CDT 2009
I just answered this question on the other thread. You can do it using COALESCE. I wrote an article on this exact thing for TechRepublic.com a while back. I'm hunting for it now. Aha! Found it! See http://www.artfulsoftware.com/infotree/tip.php?id=753 hth, Arthur