Joined: 20 Oct 2006 Posts: 6968 Location: porcelain throne
Sounds like a class project
you only want ROWS (there are no records in db2 tables)
which contain char D thru Z? (don't care about spaces, special char, lower case or numeric)
How large is the Column? (what is the length)
assuming that it is a 4 char column
WHERE SUBSTR(column,1,1) > 'D'
OR SUBSTR(column,2,1) > 'D'
OR SUBSTR(column,3,1) > 'D'
OR SUBSTR(column,4,1) > 'D'
you could also reverse it and make it
SUBSTR(column,1,1) > 'D'
SUBSTR(column,1,1) < 'A'