title: PL/SQL Remove unwanted characters from a phone number
body: <p>I have looked around and cannot seem to find a straight answer to this question. I am confused as to how I would do this. Should I be using a regular expression or is there a better way to do this. </p>
  
  <p>I have a procedure that formats phone numbers depending on what they start with and how long they are. I want to be able to clean the phone number first, before formatting it. So my tutor has thrown in a phone number that looks like this</p>
  
  <blockquote>
    <p>07A3345&amp;6543</p>
  </blockquote>
  
  <p>I want to remove the A and the &amp; from the phone number before formatting it. </p>
  
  <p>Thank you</p>