Suppose database contains mobile_no field which has records like "0715355403".....
If you want to remove front "0" and add "94", you can use the following SQL command.
select "94"||mobile_no[2,10] from sms_request
This is can used in SQL where clause, too.
