I need a query to exclude numeric values from a column where it contains numeric values like -35 , ^42 , ^ 51 etc , characters like AD, RP etc and alpha Numeric values like B80 , 7N4 etc.
I tried using this query
select code from Table minus (select code from Table WHERE code like any ('%0%','%1%','%2%','%3%','%4%','%5%','%6%','%7%','%8%','%9%'))
but this query excluded numeric values along with alpha numeric values also , but I need alpha numeric values . How to get back alpha numeric and character values in that column?
Thanks in advance
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.