SELECT IsNull(Replicate(' ',20-len(STR(MONTH(AddDate)))),'')+STR(MONTH(AddDate)) FROM News
SELECT ISNULL(REPLICATE('0',2-LEN(STR(MONTH(AddDate)))),'')+STR(MONTH(AddDate)) FROM News