Adding to strings

[MarkEmerson]

Hello people,

I have reference numbers for staff that vary from 1-4 characters long. Basically I want to make all numbers 7 characters long by adding 0's to the front of the number. The field is varchar(7).

How can i do this?

Thanks

 

[mwolf00]

select @curVal = '123'

select @curVal = replicate('0',7-len(@curVal))

print @curVal

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook

 

[SQLSister]

select replicate (0, 7 - len(field1) + field1) from table1

 

[MarkEmerson]

Thanks people

 

[mwolf00]

oopps...

select @curVal = replicate('0',7-len(@curVal)) + @curVal

Programming today is a race between software engineers striving to build better and bigger idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning. - Rick Cook