Category: SQL Server
view more software Tips and Tricks
Updated: 09/02/2014 08:09 AM
Author: Shiju Mathews
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’.