search for lowercase characters in a column
Hi all,
I have a database Oracle 9.2. There is a table called CUST with 35 million rows. In this table there is a column SURNAME defined as VARCHAR2 and length 50.
My question is this: Most of the surnames have been saved in all uppercase however a small number of them are in a mix of uppercase and lowercase. I am looking for a SQL query that will return all rows where this column contains lowercase characters. Can anyone help with a simpe query that can do this ?
Many thanks in advance.