title: Find a specific substring using Transact-SQL
body: <p>I need to pull a specific substring from a string of the form:</p>
  
  <pre><code>foo=abc;bar=def;baz=ghi
  </code></pre>
  
  <p>For example, how would I get the value of "bar" from that string?</p>