'SQL Server - How to find the rows that have a value that contains a lowercase letter?

I have a table that contains a few columns which can have older values in the lower case. I want to update these values to Upper case in case they exist. At the DB level, the collation used is SQL_Latin1_General_CP1_CI_AS How should I write a query in an SQL server to achieve this?

sql-server


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions