Select IsNull(Replicate(' ', 20 - len(SomeField))) + SomeField as SomeName from SomeTable>>
>>SELECT IsNull(Replicate(' ',20-len(STR(MONTH(AddDate)))))+STR(MONTH(AddDate)) FROM News >>>>
>SELECT REPLICATE('0',2-LEN(LTRIM(STR(MONTH(AddDate)))))+LTRIM(STR(MONTH(AddDate))) FROM News >Try
SELECT REPLACE(STR(MONTH(AddDate),2), ' ', '0')