i don't see anywhere to do it? i would think the phone was capable, but if not, i bet one of the sms/mms (handcent, etc) apps could do it?
I asssume you are talking about a text notification. You can download the app called Ringo Lite. You then can assign a specific contact a text ringtone or even a calling ringtone.