I am trying to return only values from a field that have the first letter between A-Z,
I have tried using the below but this only does one letter at a time.
UPPER(LEFT(AD_ADDR,1)) like 'A%'
The other characters will be 0-10, which I want to exclude but are formatted as strings, so using IS_INTEGER doesn’t work.
SELECT * FROM tab WHERE AD_ADDR RLIKE '[a-zA-Z].*';