[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 295
  • Last Modified:

Add 0044 to tel number

I have a table in ms access called mobile and a field called txt. The field txt holds mobile numbers. I need to add "0044" to the beginning of each number with sql query
0
oldmillsaddlery
Asked:
oldmillsaddlery
  • 2
1 Solution
 
Rikin ShahMicrosoft Dynamics CRM ConsultantCommented:
Update Mobile
Set txt = '0044' + txt
--add condition if any
--where condition
0
 
Rikin ShahMicrosoft Dynamics CRM ConsultantCommented:
Or if you want to select it then-
Select '0044' + txt AS txt from mobile
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now