Doing a CASE WHEN in a where clause smells like amatuerism.

Ouch....you might want to re-think that one.

If that indeed is true, then we have an awful lot of SQL authors, MVPs, and the good Lord J.C. himself (Celko) who would fall into that (all have printed queries that use it....it was about 6 years ago when I starting seeing a lot of it in print)