title: SQL Substring variable text within URL string
body: <p>I'm trying to parse information from a column of URLS in SQL Server 2012</p>
  
  <p>The basic structure is</p>
  
  <pre><code>http://www.domainsomething.com/?test/campaign=abc&amp;kwd=jdc ftp&amp;catgory=brnd
  </code></pre>
  
  <p>Where I need to grab the parameters from the <code>kwd=</code> value. In the above example, it would be the '<code>jdc ftp</code>', but this would might be different for all the URLs in my column.  I've tried <code>CHARINDEX</code> and <code>LEN</code>, but I can't seem to put the syntax together correctly.</p>