Find a super simple SQL statement, online etc. Thank you!

slugger

Need to get: 00008
Now getting: 8
A total of 5 digits need to be filled with 0 before the default bit; what should I do!

michealhenry

select right('00000'+ '8',5)

我是杀人狂

select right('10000'+'8',5)
result:
------
00008

(The number of rows affected is 1 row)

slugger

Brother upstairs, the default position in front is not fixed!! What should I do, thank you!!

dream88

Upstairs correct solution, too fast

菜鸟明星

Declare @Num Int
Set @Num=8
Select Right(('00000'+Cast(@Num As Varchar)),5)

slugger

Oh. Got it!! Thanks

wgfxman

select rtrim(right('00000', 5-len('8'))+'8')