How to add 0000 in row number in sql server?

Question

Hi,

 

I want to create sequence number based on rownumber. i want to add 0000 before rownumber based on another column. how to do it in select query

 

00001

00002

00003

00004

00005

00006

00007

00008

00009

00010

00011

....

.....

00100

00001

00002 

 Like this...