title: How to split String in SQL Server 2008
body: <p>I want to split a string using a T-SQL query without creating any function or stored procedure.</p>
  
  <p>For example I have a string like </p>
  
  <pre><code>"Attribute "Request Type" value: Prior; Attribute "Job Type" value: New; Attribute "Proof Number" value: 1; Attribute "Vision Number" value: 534290;"
  </code></pre>
  
  <p>Now I want get value for <code>Job Type</code> which is <code>New</code>.</p>
  
  <p>Please suggest me any way to do this.</p>
  
  <p>Thanks in advance</p>