检索纯数字，这样的sql怎么写？

[pen_scholar]

判断表t_a的col_1列中值必须是数字0-9，
当有不全是数字的列存在时，将其检索出
这样的sql怎么写？

[百年树人]

where isnumeric(col)=1

[百年树人]

--当有不全是数字的列存在时，将其检索出

select * from tb where where isnumeric(col)=0

[--小F--]

select col_1 from t_a where col_1 between 0 and 9

[angellan]

WHERE col NOT LIKE '%[0-9]%'

[--小F--]

[Quote=引用 3 楼 fredrickhu 的回复:]
SQL codeselect col_1 from t_a where col_1 between 0 and 9
[/Quote]
--不是0到9的话加上not

select col_1 from t_a where col_1 between 0 and 9

[--小F--]

[Quote=引用 5 楼 fredrickhu 的回复:]
引用 3 楼 fredrickhu 的回复:
SQL codeselect col_1 from t_a where col_1 between 0 and 9

--不是0到9的话加上not
SQL codeselect col_1 from t_a where col_1 between 0 and 9
[/Quote]
晕

SQL codeselect col_1 from t_a where col_1 not between 0 and 9

[you_tube]

select 1 from tab where patindex('%[a-z,A-Z]%',col1) > 0

[S468160201880427556]

select case when ISNUMERIC(col_1)=1 then '数字' else '字符' end from t_a

[光宇广贞]

[Quote=引用 8 楼 S468160201880427556 的回复:]
select case when ISNUMERIC(col_1)=1 then '数字' else '字符' end from t_a
[/Quote]

顶美女，数据库的专家啊。

[JonasFeng]

[Quote=引用 7 楼 you_tube 的回复:]
SQL codeselect 1 from tab where patindex('%[a-z,A-Z]%',col1) > 0
[/Quote]

学习！
这个也OK！

select * from tb where where isnumeric(col)=1 and col between 1 and 9 

[fuda_1985]

只一个字,顶~都说出来了.

[soft_wsx]

没话说了

[寻找Python之禅]

来迟了，没我份了

[hery2002]

.

[kingdomxpxp]

.