1、varchar型--》int型
CONVERT(int,**)
--或
cast (** as NUMERIC)
2、裁取字符串 eg:varchar型的age为'85~',需要裁掉 ' ~'
SUBSTRING(**, 0, LEN(**))
SUBSTRING(age, 0, LEN(age))
3、eg:varchar型的age为'85~',需要裁掉 ' ~',并转化为 int
CONVERT(int,SUBSTRING(**, 0, LEN(**)))
CONVERT(int,SUBSTRING(age, 0, LEN(age)))