How do we check whether a column has any letters or not

I want to use a query like:

select * from test

where data in the column has alphanumeric values.

e.g. if column rollno has values like 20,30,40,50C,30F, then how do I find the values which have 50C and 30F types of values?

Answers


If your data is varchar2 and you want to validate it against a pattern, you can use the REGEXP_LIKE function

For instance, to select the fields that are digits followed by non digit characters, you can use:

select * from table
where regexp_like(field, '^\d+\D+$');

From your list, this will return 50C and 30F


Need Your Help

intercepting the GetCustomUI callback in a VSTO3 addin

vb.net ms-word vsto

I've got a VSTO3 Word addin that makes use of custom ribbons and taskbars, etc.