SQL的内建函数中字符串转成数字的函数是哪个

[oldforest]

要将'37200'这么一个字串转成数字：37200　
有没有函数可操作

[pengdali]

select cast('37200' as int)

[pengdali]

select cast('37200' as int)

[happydreamer]

select cast('12323' as bigint)

[txlicenhe]

convert(int,'37200')

[lionstar]

select convert(int,'1548877')
开心就好！！！

[zarge]

select cast('37200' as int)

[lyguo]

以上都可以吧

[stonepeter]

要是"37200axb" "23-20"这样的数据想转成"37200" "23"呢？

[welyngj]

select substring('37200axb',1,5),substring('23-20',1,2)

[zarge]

要是"37200axb" "23-20"这样的数据想转成"37200" "23"呢？
：不能直接转，只能取出数字部分再转
：Select cast(substring('37200axb', 1, 5) as int)
: Select cast(substring('23-20', 1, 2) as int)

[stonepeter]

看来还真是没招……