Phone Number formating issue
hello, i have a table in my database that imports phone numbers from a seperate database. The problem is the phone numbers imported are not in the format matching the rest of my database so i cant set up automatic search scripts. i need a script tigger to de-format the imported phone number. for ex: the imported phone numbers look like this (xxx) xxx-xxxx when i need it to look like this xxxxxxxxxx. can anyone help me?