auto lenght

HI

Declare @a char(7)

if the lenght of the inserted value in @a is less than 7. the zero's should
be added on the left side to make it of lenght 7.

set @a = aaaa

then 3 zero's should be added on the left side
As the lenght of @a may vary so how can zero's should be added on the left
side autometically to make it of lenght 7.

Regards...



.