>>Try to cust it to character type

SELECT CAST(REPLACE(STR(MONTH(AddDate),2), ' ', '0') AS char(2))

>
>Same thing

Strange, it returns 2 character field (not memo) for me.