将字符串转换为数字的函数

[ljyyhlp]

在sql中将字符串转换为数字的函数

[lxzm1001]

select cast('123' as int)

[lxzm1001]

select convert(int,'123')

[WorldMobile]

如果是oracle

select to_number('123') into :ll_number from dual;

[pkyang]

楼上都说了