title: How to extract this specific substring in SQL Server?
body: <p>I have a string with a specific pattern:</p>
  
  <pre><code>23;chair,red [$3]
  </code></pre>
  
  <p>i.e., a number followed by a semicolon, then a name followed by a left square bracket.</p>
  
  <p>Assuming the semicolon <code>;</code> always exists and the left square bracket <code>[</code> always exists in the string, how do I extract the text between (and not including) the <code>;</code> and the <code>[</code> in a SQL Server query? Thanks.</p>