Padding Zeroes To An Int

Hi,

I need a simpler way of doing this:

I've a number column which I need to show as a 3 digit field in a string:
Example:
number =1; string = 010
number =10; string =100

is there any function that can do this string manipulation?


Currently I'm using a CASE statement to check the length of this number column,
if its single digit I use:
SUBSTRING(('0' + CONVERT(VARCHAR,CONVERT(INT,ISNULL(D.Number,E.Number)))+'0'),1,3)

else I use
CONVERT(VARCHAR,CONVERT(INT,ISNULL(D.Number,E.Number)))+'0')

Is there a better way of doing this?

Thanks,
Subha