N Number11 Member Local time Today, 19:45 Joined Jan 29, 2020 Messages 623 Dec 17, 2021 #1 I need to change some telephone numbers entered with a 44 prefix and then once done add a new prefix of zero so best to trim the first two numbers?
I need to change some telephone numbers entered with a 44 prefix and then once done add a new prefix of zero so best to trim the first two numbers?
June7 AWF VIP Local time Today, 10:45 Joined Mar 9, 2014 Messages 6,083 Dec 17, 2021 #2 Maybe use an UPDATE action SQL. Are all telephone numbers the same number of characters? They won't be after this edit. UPDATE table SET field = "0" & Mid(field, 3) WHERE Left(field, 2) = "44"; Last edited: Dec 17, 2021
Maybe use an UPDATE action SQL. Are all telephone numbers the same number of characters? They won't be after this edit. UPDATE table SET field = "0" & Mid(field, 3) WHERE Left(field, 2) = "44";
gemma-the-husky Super Moderator Staff member Local time Today, 19:45 Joined Sep 12, 2006 Messages 16,094 Dec 18, 2021 #3 are your fields numbers or strings?
