SQL – Case sensitive

Suppose you need to perform a SQL query and you need for it to be case sensitive or case insensitive, and either your database is...