https://blog.csdn.net/qh0526wy/article/details/116378789

将字符串转数字

SELECT CAST('3.02' as decimal)

将数字转成字符串

SELECT CAST( sid as text) as sid

原文出处：/show_1IX7YVpRkin8.html