Select的简单问题！在线等待！解决马上结帖
表A中有一个字段B，B中只要有除数字以外的串,就全部显示出来！请问SQL怎么写

------解决方案--------------------
select * from A where patindex( '%[^0-9]% ',B)> 0
------解决方案--------------------
select *
from 表A
where ISNUMERIC(isnull(字段B, 'a '))=0
------解决方案--------------------
select b from a where isnumeric(b) <> 1
------解决方案--------------------
select * from A where isnumeric(isnull(b, '哈哈 '))=0
------解决方案--------------------
create or replace function isNumber(p_in varchar2) return varchar2 as
i number;
begin
i:=to_number(p_in);
return 'TRUE ';
exception
when others then
return 'FALSE ';
end ;

--oracle中没有函数 你要自己建一个函数


select *
from 表A
where isNumber(字段B)= 'FALSE '

------解决方案--------------------
SQL> create table my(name varchar2(20));

Table created.

SQL> insert into my select '1 ' from dual;

1 row created.

SQL> insert into my select '2 ' from dual;

1 row created.

SQL> insert into my select 'abc ' from dual;

1 row created.


SQL> select * from my where trim(translate(name, '0123456789 ', ' ')) is null;

NAME
--------------------
1
2
------解决方案--------------------
楼上的解决了~
------解决方案--------------------
select * from my where trim(translate(name, '0123456789 ', ' ')) is not null;