Home / Software / Tips and Tricks / How to select rows in where one of the column values is in capital letters?

How to select rows in where one of the column values is in capital letters?

Updated:  09/02/2014 08:09 AM
Author:  Shiju Mathews

Status:    Resolved.


This is one of the common situation occurred in data clean up. For example you will get a requirement that convert all the ‘firstname’ to Title case where ‘firstname’ is in all caps. May be you don’t want to run a update query for all the rows.

Take a look at this query which only select all caps ‘firstname’.