title: How to split string using delimiter char using T-SQL?
body: <p>I have this long string in one of the columns of the table. I want to get only specific information:-
  My Table structure:-</p>
  
  <pre><code>Col1 = '123'
  Col2 = 'AAAAA'
  Col3 = 'Clent ID = 4356hy|Client Name = B B BOB|Client Phone = 667-444-2626|Client Fax = 666-666-0151|Info = INF8888877 -MAC333330554/444400800'
  </code></pre>
  
  <p>My select statement is:-</p>
  
  <pre><code>Select col1, col2, col3 from Table01
  </code></pre>
  
  <p>But in Col3 I just need 'Client Name's value which is 'B B BOB'. </p>
  
  <p>In Col3 -</p>
  
  <ul>
  <li><p>Column delimiter is '|' pipe char (eg. 'Client ID = 4356hy') </p></li>
  <li><p>Key Value delimiter is ' = ' equal to sign with one white space (leading and trailing).</p></li>
  </ul>
  
  <p>Please help.</p>