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 SQL CASE statement is a way of expressing conditional logic in SQL. It allows you to specify different outcomes based on the evaluation of one or more expressions. You can use the SQL CASE ...

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), ...