SQL CASE and IF statements are ways of adding conditional ... based on certain criteria or expressions. For example, you can use a CASE statement to assign different labels or categories to ...

The CASE statement in SQL is a way of creating branches or alternatives in your query, similar to the IF-THEN-ELSE logic in programming languages. You can use the CASE statement to compare values ...

I'm not sure if I remember wrongly, I see the COLLATE NOCASE append in the sql query very long time ago (may be not COLLATE NOCASE,but something else , all I remember is my query is case insensitive), ...