I have implemented a solution very similar to the one in Ten Centuries post for a similar problem. I think it is simpler, more elegant and easier to read than...

Additional options relative to the section on conditional WHERE clause without using a Dynamic Query

The COALESCE function can be used in a similar fashion as you are describing how to...