>>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>)
--sb--