Address Matching
<p>I'm trying to provided results from Old customers based on an address.</p>

<p>To do this i'm looking at the new customers address and then looking at the old customer that was once at the same address.</p>

<p>My issue is that the addresses get put in different some of the time for example.</p>

<pre><code>Result 1- 
    address 1 = 37 
    address 2 = Duke Street 
    Address 3 = Chelmsford 
    Address 4 = Essex 
    Address 5 = NULL 
    Post Code = CM1 1HY


Result 2-
    address 1 = 37 Duke Street 
    address 2 = NULL 
    Address 3 =NULL 
    Address 4 = NULL 
    Address 5 = Chelmsford 
    Post Code = CM1 1HY
</code></pre>

<p>Is there any way that i can bring both of the results back.</p>

<p>I have tried the SOUNDEX function but seems not to work all the time.</p>