How to detect alphabet characters in row of a text field

1

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…

2

@Informer

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)

Thanks
@balaji.ramaswamy

3

Many Thanks Balaji I will try code for now…