Hi Michael,

I don't understand why it doesn't work for you. I copied and pasted the line from the web page directly into Query Analyzer and it worked perfectly. What error are you getting?

Liam




>>Left out the second arg for IsNull()...
>>
>>

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

>
>This doesn't work either:
>
>

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