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
>
Liam O'Hagan
MCP VFP Desktop Apps