I have a website offering web2phone sms services. and I have a table which users register on my website. However i would like to keep track of certain phone numbers they enter.
Knowing that international formats of my country starts with 234 and phone numbers start with 080 i would like to search for any entry starting with 080 and update it with a trigger on insert to 234
how do i get this done efficiently, cos am stuck
declare @phone int , @phone2 int
select @phone = (select phone from inserted)
select @phone2 = (select phone from inserted)--Am trying to make this update the phone with the international format
if @phone like 080%
set phone =