Web Analytics Made Easy -
StatCounter Regex - Remove 0 and Add Country Code - CodingForum

Announcement

Collapse
No announcement yet.

Regex - Remove 0 and Add Country Code

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Regex - Remove 0 and Add Country Code

    i have alot of numbers with 10 digits like this

    0987654321

    I want a sql query that will remove the 0 and add 353.

    Is there any body that can help me with this please?
    Last edited by kevinkhan; Sep 30, 2016, 01:37 PM.

  • #2
    What is the name of the column that holds that data and what is the data type? Is the zero always the first thing in the field? Do you want the 353 added to the number or appended to the front of it?
    Dave .... HostMonster for all of your hosting needs

    Comment

    Working...
    X