数字前加0补齐
使用RIGHT ( character_expression , integer_expression ) 返回字符串中从右边开始指定个数的字符。
例如:
SELECT RIGHT('FirstName', 5) AS 'First Name' --- tName
select RIGHT ('000000' + cast ( 1 as varchar(6) ), 6) --- 000001
select RIGHT ('000000' + cast ( 12 as varchar(6) ), 6) --- 000012
select RIGHT ('000000' + cast ( 123 as varchar(6) ), 6) --- 000123
select RIGHT ('000000' + cast ( 1234 as varchar(6) ), 6) --- 001234
select RIGHT ('000000' + cast ( 12345 as varchar(6) ), 6) --- 012345
select RIGHT ('000000' + cast ( 123456 as varchar(6) ), 6) --- 123456
posted on 2010-05-22 16:14 NewSunshineLife 阅读(501) 评论(0) 编辑 收藏 举报