My apologies if this has been covered already, but I searched, and could not find it.
I receive automated pages in the form of SMS messages from work constantly. It would be nice to have a different alert tone for those SMS's. Is there a way or a 3rd party program that I can use to set custom text message alerts per contact?
I tried some PhotoContacts program, but all it did was screw up my today screen.

Any assistance is greatly appreciated!