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.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.