>>In general, it would be a string you want to pad. In this case, I meant a column named 'col1' in a table.
>
>Thanks, that works.

You're welcome. To clarify further, a pseudo code would be

 RIGHT(REPLICATE('0', <len to pad to>) + <character expression to pad>, <len to pad to>)