Luis Cazares (9/26/2016)
I can't picture a situation in which a CASE statement could be the only option in a WHERE clause.I, however, can see a lack of understanding of SQL. I said never because most newbies can't differentiate a valid reason from an invalid reason. I don't intend to sound harsh, but it's just because I've seen so much bad coding, that I don't trust anyone.
When working with a third-party solution, you sometimes have limited options. I have been in situations where using a CASE expression in a WHERE clause was the only option available without invalidating our maintenance contract with that vendor.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA