I really do not recomend use CASE in the where, I have seen a lot of problems with index invalidation in sql server 2000 and 2005, if you need use...