>>Something like this?
>>

Select IsNull(Replicate(' ', 20 - len(SomeField))) + SomeField as SomeName from SomeTable

>
>I've been trying various combinations such as:
>
>

>SELECT IsNull(Replicate(' ',20-len(STR(MONTH(AddDate)))))+STR(MONTH(AddDate)) FROM News
>

>
>but, can't make anything work.

Ok, I'm getting close. The following returns the proper value but it returns it in a memo field:

SELECT REPLICATE('0',2-LEN(LTRIM(STR(MONTH(AddDate)))))+LTRIM(STR(MONTH(AddDate))) FROM News