Mask a string

[PavanKumarU]

hi,
Got a quick question. I dunno if i am misisng a function here.
I want a string which (if it is) is 5 chars in length to appear in 7 chars length.
for example.
If i am getting a string from database like 'Hello' i want it to be padded with two zeros like 00hello.
Can i do this is sql?
Any help is much appreciated.
Thanks
Pavan

 

[topher0303]

try the replicate function:

REPLICATE('0', 7 - len(mystring)) + mystring

Chris.

 

[PavanKumarU]

hi,
Thanks Chris,
Thats exactly what i did.
Appreciate your help.
Thanks,
Pavan