Open SQL Statements Cook Book

Find Records Only Containing Lower Case

From a set of records containing lower case and upper case contents in a given field return only the records containing lower case contents in the field in question.

SELECT
   /BIC/AZBWTEST7~REQTSN,
   /BIC/AZBWTEST7~ADDRNUMBER,
   /BIC/AZBWTEST7~POST_CODE1,
   /BIC/AZBWTEST7~COUNTRY
FROM
  /BIC/AZBWTEST7
WHERE
  UPPER( /BIC/AZBWTEST7~POST_CODE1 ) <> /BIC/AZBWTEST7~POST_CODE1