title: How to get substring in TSQL
body: <p>I want to extract special word from a sentence in SQL Server.</p>
  <p>For example I want to extract <code>No-13</code> from <code>'Street3 NO-13 Floor 4th'</code></p>
  <p>Following code is my primary code, but I can't find the last index to get special word:</p>
  <pre><code>SELECT PATINDEX('%Y[^][0-9]%', 'Street3 NO-13 Floor 4th')
  </code></pre>