MySQL Forums
Forum List  »  General

Query To Find Lower Case Letters In A Column
Posted by: Scott Krise
Date: May 10, 2019 10:29AM


I wrote a query that I thought was simple...but its proving not to be. All Im trying to do is find all the records that contain at least 1 lower case letter.

So, I thought something like this would work:

SELECT * FROM in_master i where upper(upc) <> upc

But, it doesn't. I saw something on-line where you could use the COLLATE in your query...but that didnt seem to work either.

Anyone know what I'm missing?



Options: ReplyQuote

Written By
Query To Find Lower Case Letters In A Column
May 10, 2019 10:29AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.