Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Search for fields that do not contain uppercase characters

845908Mar 14 2011 — edited Mar 14 2011
I'm trying to identify suspect names in our database. One of the tests is to look for values in columnA that do not contain uppercase values. That is, all names in our database should have at least one capital letter. Is there a more efficient way to run the following?
SELECT columnA
FROM mytable
WHERE columnA not like '%A%' 
           and columnA not like '%B%'
           and columnA not like '%C%'
           ... (repeat for D-Y)
           and columnA not like '%Z%'
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 11 2011
Added on Mar 14 2011
6 comments
588 views