title: Searching and Substrings in SQL
body: <p>I want to use SQL on DB2 for i (formerly known as iSeries or AS/400) to extract a value from a string.  </p>
  
  <p>The string contains JSON-like list of delimited key:value pairs.  Example:</p>
  
  <pre><code>("EventType":"XYZ","EffectiveDate":20131000,"ClientNo":2012020860902)
  </code></pre>
  
  <p>Given a key string such as "Event Type", I want to find the value after the colon (':'), which in this case would be "XYZ".  But please keep in mind that my key string might not always be "Event Type".</p>