34,587
社区成员
发帖
与我相关
我的任务
分享有关int转varchar
怎么按自己的要求在前面补0呢?
如我想转为varchar(3), 1--->'001'
如我想转为varchar(5), 2--->'00002'
如我想转为varchar(3), 1--->'001'
如我想转为varchar(5), 2--->'00002'
...全文
请发表友善的回复…
发表回复
nboys 2003-07-21
- 打赏
- 举报
select right(('00000'+convert(varchar,5)),5)
select right(('000'+convert(varchar,3)),3)
select right(('000'+convert(varchar,3)),3)
97866 2003-07-21
- 打赏
- 举报
SELECT STUFF('000',3,1,1)
SELECT STUFF('00000',5,1,5)
SELECT STUFF('00000',5,1,5)
pengdali 2003-07-21
- 打赏
- 举报
select right(cast(1+1000 as char(4)), 3)
select right(cast(2+100000 as char(6)), 5)
select right(cast(2+100000 as char(6)), 5)
愉快的登山者 2003-07-21
- 打赏
- 举报
select right(cast(1+1000 as varchar), 3)
select right(cast(2+100000 as varchar), 5)
select right(cast(2+100000 as varchar), 5)
