SQL Server is case insensitive: he does not care about ‘A’ ou ‘a’. Save time and don’t use functions like LOWER and UPPER when comparing VARCHARs.Basic tips on tuning SQL Server queries602Erick MendonçaAravind V ShibuFollowJul 10, 2017 · 1 min readThis actually depends on the type of server/database collation.