How to detect alphabet characters in row of a text field

Hi All,

Just trying to find the code in Dremio that will allow me to sive out the rows which actually are alphanumeric
as opposed to numeric. The data type to this column is text and majority of the values are numeric.

Many Thanks for your help…


Let me see if I can get you a function, but a simple method would be like below

SELECT * FROM <table_name> WHERE upper(col1) != lower(col1)


Many Thanks Balaji I will try code for now…