title: T-SQL get substring
body: <p>I am looking to get an order number from a column named KEY_Ref, this ref column have various contents, but some rows look like this</p>
  <pre><code>LINE_NO=15^ORDER_NO=176572^RELEASE_NO=1^
  </code></pre>
  <p>Now I am interested in getting the value for ORDER_NO (176572 in this case)</p>
  <p>How would I (In SQL Server) go about getting this (Or other) value from the main string</p>
  <p>The logic is always
  key1=value1^key2=value2^key3=value3^</p>