title: Join on phone numbers in different formats
body: <p>I need an oracle SQL join on two tables on fields with phone numbers that have different formats.  The field on one table is the format 555-555-5555 and the other (555) 555-5555.</p>
  <p>What is the syntax that could make this work?  The tables are small enough I could probably get by with dropping area codes and just focus on the last 4 digits.</p>
  <p>Is it possible?  If I can't do a join I'm curious of the syntax for a simple compare such as:   <code>Where last4(phonenumber) = '4567'</code></p>