Anyway, got asked if there was a way to return a resultset of data based on the leading character, the use case was to ignore all strings starting with a,b, or d and return e to z.
Fairly straight forward but a good SQL to have.
I simply grab the first character in the varchar and compare it's ASCII value to the ASCII value D.
SQL> select * from t;
SQL> with data as (
2 select ascii(upper(substr(a,1,1))) a_val,a from t
4 select * from data where a_val not between ascii('A') and ascii('D') order by a