• Assuming the author does mean a CASE expression, and then the answer is "yes", you would have to wonder why you would use it at all, as (in the example given in the question):

    select *

    from MyTable

    where mycompare1 = 'A'

    is surely much simply to write and understand.

    Can anyone give an example of where a CASE expression should/could be used in a WHERE clause?

    Life: it twists and turns like a twisty turny thing