title: How to remove special characters and leading zeros from field in sql
body: <p>I have field that has something like this 083_33:152#7 0100 and i want to remove all the special characters, spaces, leading and trailing zeros etc at one time.  How can i do that?  the output should be like this:
  8333152701
  here is what i have</p>
  
  <pre><code>select * from myTable where REPLACE(LTRIM(REPLACE(part_number, '0', ' ')), ' ', '0') =  '8333152701'
  </code></pre>
  
  <p>the query should return this: 8333152701
  Thanks </p>