title: SQL how to extract middle of string
body: <p>I want to only get the unit number out of this string:</p>
  
  <pre><code>'&lt;p&gt;The status for the Unit # 3546 has changed from % to OUTTOVENDOR&lt;/p&gt;'
  </code></pre>
  
  <p>The note is always exactly the same but the unit number changes. How do I extract just the unit number?</p>
  
  <p>Thanks!</p>