Mask a string

[PavanKumarU]

hi,
Got a quick questions. 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]

answer is in your other post

 

[vadimg]

select '00'+ ColumnNameContainingString from Table

will work if ColumnNameContainingString has a character data type. If it's something else:

select '00'+ cast(ColumnNameContainingString as varchar) from table