Hi there. Clearly the Latin1_General_CI_AI collation is coming from somewhere. If not coming from a column being used in that CASE expression, then it's possible it is explicitly set using a COLLATE clause in that expression. Can you please update the question to include the query being executed. It is possible that the "column" with the Latin1_General_CI_AI collation is in a DMV or some other system catalog view, and not a column in your user database. But without seeing the query, there is no way to move forward on this.
1 Like