title: Parse result text during SQL query or on Server side
body: <p>I have given an example of data table like below. key_value is unique and is used to get search results. What I do currently is query with key_value and then parse the content.</p>
  
  <pre><code>+-----+-------------+----------------+
  | id  | key_value   | content        |
  +-----+-------------+----------------+
  | 1   | 001         | 100SW          |
  | 2   | 157         | 80SW/20CO      |
  | 3   | 222         | 50EA/50CMD     |
  | 4   | 275         | 1EA/29LI/70BW  |
  +-----+-------------+----------------+
  </code></pre>
  
  <p>What I currently have: (example for key_value: 275)</p>
  
  <pre><code>+-----+-------------+----------------+
  | id  | key_value   | content        |
  +-----+-------------+----------------+
  | 4   | 275         | 1EA/29LI/70BW  |
  +-----+-------------+----------------+
  </code></pre>
  
  <p>What I want to achieve is something like this. (example for key_value: 275)</p>
  
  <pre><code>+-------------+----------+----------+
  | key_value   | percent  | content  |
  +-------------+----------+----------+
  | 275         | 1        | EA       |
  | 275         | 29       | LI       |
  | 275         | 70       | BW       |
  +-------------+----------+----------+
  </code></pre>
  
  <p>Is it possible to achieve on server side with queries?</p>
  
  <p>P.S.: Currently using SQL Server 2005 if it matters.</p>