You can use below function to get all the records starting from capital letter 'A' to 'Z'
char2hexint( substr(EMP_NAME,1,1)) between '41' and '5A'
Syed Mujtaba Ahmed
How do we check if a particular column has upper case or lower case values. UPPER will get only all the values in UPPERCASE. But how to check if a column's existing values are in upper case or lower case?