select * from ggws_jktjb where id not in (
select id from (select id , tiwen,ISNUMERIC(tiwen) as x from ggws_jktjb) as y
)
select id,tiwen from ggws_jktjb where patindex('%[0-9]%',tiwen)<=0
select * from ggws_jktjb where id not in (
select id from (select id , tiwen,ISNUMERIC(tiwen) as x from ggws_jktjb) as y
)
select id,tiwen from ggws_jktjb where patindex('%[0-9]%',tiwen)<=0