Problem. A string comparison is case sensitive when you don't want it to be, or vice versa.

How do I compare strings in SQL case-insensitive?

You can change either the session or the database to use linguistic or case insensitive searching. You can also set up indexes to use particular sort orders. SELECT STRCMP("string1", "string2"); this returns 0 if the strings are equal.

How does SQL Compare case-sensitive data?

To perform a case-sensitive comparison, SQL Data Compare uses the Latin1_General_BIN collation. For example, if you compare Widget and widget, when the project option is not selected, SQL Data Compare considers the data to be identical. When the option is selected, SQL Data Compare identifies the case difference.