Quelltext der Seite 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.<syntaxhighlight lang="sql">
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
</syntaxhighlight>
[[Kategorie:SQL]]