Case-Insensitive Search in SQL
use-the-index-luke.com/sql/where-clause/functions/case-insensitive-searchUsing UPPER or LOWER for case-insensitive search is not a good practice. Prefer using a _CI collation if possible or at least add the right indexes to make your query fast.