title: replace only exact words with a list of words from a table
body: <p>this question is a part of this one</p>
  
  <p><a href="https://stackoverflow.com/questions/19718426/limit-records-in-cursor-by-using-a-variable/19719499#19719499">limit records in cursor by using a variable</a></p>
  
  <p>the original question was a 2 part question, 1 part being, IS THERE A BETTER WAY TO DO THIS</p>
  
  <p>i have code that works but it's EXTREMELY slow, about 2 seconds for each record.</p>
  
  <p>so i have a table, NR_POSTAL_ABBR, that has 2 fields and about 400 records</p>
  
  <pre><code>ReplaceWhat       ReplaceWith
  Ave               Avenue
  St                Street
  </code></pre>
  
  <p>i want to be able to replace the Address field in another table with the valules from the table above</p>
  
  <p>so if i have an address 123 Main St - it should say 123 Main Street</p>
  
  <p>if i have 123 Main Street - it should stay 123 Main Street, it shouldn't become 123 Main Streetreet</p>
  
  <p>the table with addresses has a few million rows, is there a fast way of doing this?</p>
  
  <p>thank you</p>