title: Add a space after period if one does not exists
body: <p>I'm trying to add a space after any periods that do not have one.</p>
  
  <p>Here's my problem:</p>
  
  <p>I have addresses like:</p>
  
  <pre><code>123 W.Redtail Drive
  548 N.Smokey Mountain Pass
  </code></pre>
  
  <p>There should be a space after that period, most of the time there is but ~15% of the time it's omitted. </p>
  
  <p>I thought I could just do this but then I realized this would (even it it did work, it would replace that first character with a blank space so this idea is no good.</p>
  
  <pre><code>update directory
  set ADDR1_CLEANSED = REPLACE(addr1_cleansed,'._','. ')
  </code></pre>
  
  <p>but this does not work, is it possible to accomplish this? Most of the time the space exists so I don't just want to add another one....</p>
  
  <p>Thanks for any suggestions.</p>