I have written a brief description of this exact problem here:

OR Condition Performance

I have lost count of the number of times I've seen this, and at first sight it looks like a good idea. But the fact is, it won't use an index, so an alternative like dynamic SQL has got to be considered.

I haven't tried the COALESCE solution. I can feel a test coming on 🙂