ADO.NET学习笔记--类型转换函数

CAST ( expression AS data_type)

CONVERT ( data_type, expression)

SELECT FIdNumber,

RIGHT(FIdNumber,3) as 后三位,

CAST(RIGHT(FIdNumber,3) AS INTEGER) as 后三位的整数形式,

CAST(RIGHT(FIdNumber,3) AS INTEGER)+1 as 后三位加1,

CONVERT(INTEGER,RIGHT(FIdNumber,3))/2 as 后三位除以2

FROM T_Person