MS SQL Server: Case Sensitive Search

Sometimes you need to search your database case-sensitive. But: Microsoft SQL Server is usually configured to be case-INsensitive. But there’s no need to reconfigure the whole database, here are my 2 favorites to lookup data: cast column-value and searchterm to...