>Yes, I can remove the WHERE, I guess. And I did try something like you suggested 1=1 but I thought it was, kind of, kludgy. But I guess this is the only way. I wonder if there is a huge performance hit of 1=1 vs removing the WHERE all together.
It's kludgy because it's not necassary. The SQL Server query optimizer is very good so most likely there wouldn't be any performance hit but it's always a good idea to test it.
--sb--