title: SQL join on two columns with different format
body: <p>I have a column in <code>TABLE1</code> with Numbers</p>
  
  <pre><code>      Id
        4-157-802 
        354-332
        33-989-083
        5-525-688 
  </code></pre>
  
  <p>I have a column in <code>TABLE2</code> with same numbers but without the dash (-)</p>
  
  <pre><code>      Id
        4157802 
        354332
        33989083
        5525688 
  </code></pre>
  
  <p>I tried writing a join statement to join these tables based on these two columns as follows, its not working.</p>
  
  <pre><code>Select * from TABLE1
  where
  TABLE1.ID = TABLE2.ID
  and TABLE2.ID in ('5525688')
  </code></pre>
  
  <p>Need help with this problem. Any help is appreciated.</p>