updating numbers

  • Thread starter Thread starter rudwan
  • Start date Start date
R

rudwan

hi
i have telephone numbers stored into TelphNum.TelphTable ,
in according to telecome company , numbers will be updated
by adding additional ziro after the second digit ,
for example : 456862321 will be convert to : 4506862321
how do i can make that ?
 
create an update table. For the "Update to:" enter...

=left([TelphNum],2) & "0" & Right([TelphNum],7)


Hope that helps.

Rick B


hi
i have telephone numbers stored into TelphNum.TelphTable ,
in according to telecome company , numbers will be updated
by adding additional ziro after the second digit ,
for example : 456862321 will be convert to : 4506862321
how do i can make that ?
 
thnaks
that is also ok
-----Original Message-----
1. Back up your table.
2. Create a query

UPDATE table1 SET telnum = val(left(cstr([telnum]),2)
Click to expand...
& "0" & mid(cstr([telnum]),2));
 
Back
Top