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

转载于:https://www.cnblogs.com/DaiMaDi/archive/2013/02/28/2937034.html