<p>I have a table on SQL2000 with a numeric column and I need the select to return a 01, 02, 03...</p>

<p>It currently returns 1,2,3,...10,11...</p>

<p>Thanks.</p>

Does this work?
```
```
SELECT REPLACE(STR(mycolumn, 2), ' ', '0')
```
```
From
http://foxtricks.blogspot.com/2007/07/zero-padding-numeric-value-in-transact.html