How many uppercase and lowercase characters in a column.

Figure out how many uppercase, how many lowercase characters are in a column, we are also interested in how many are neither uppercase or lowercase. For bonus points, you can add 3 more columns to the output, one column will hold only uppercase characters, one column will hold only lowercase characters, one column will hold only characters that are neither uppercase or lowercase.

The MrClean Approach (Regular Expression) The NoBrainer and Boring Approach (PL/SQL Objects) The Thoughtful Approach (Inspired by Adrian E solution) And since I fell for Python lately ... Inspired by: http: //blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/sql-puzzle-how-many-uppercase