How can I do the following stmt:
select * from table where column has any uppercase letters; <-- how to write this
You can filter with a regex:
select * from mytable where mycolumn ~ '[A-Z]'
Another approach is string comparison:
select * from mytable where lower(mycolumn) <> mycolumn
Answered By – GMB
Answer Checked By – Robin (BugsFixing Admin)