We are currently having mobile numbers of few Requesters captured in the database. We have also setup an SMS delivery system where the Email Notification sent to an email gets converted to SMS. In this regard, we would like to ensure that the SMS notification email automatically gets sent to an email id which is formatted out of the Mobile number by adding some suffix to the Mobile number.

For ex. if the mobile number entered in the Mobile number field is 9512345678, then the SMS notification EMail should automatically be sent to the EMail ID 9512345678@abc.com

Do we need to run an update query to achieve the above objective or can it be done automatically.