title: How to split string and get data in sql Trigger
body: <p>I have created 1 table and there is 1 column named <code>data</code> . In data field i am getting data like:</p>
  
  <pre><code>{"ip":"xxx.xx.xx.xxx","power":"7.15","sat":"10","status":"ok"}
  
  {"ip":"xxx.xx.xx.xxx","power":"7.15","sat":"10","capacity":"20","status":"ok"}
  
  {"ip":"xxx.xx.xx.xxx","power":"7.15","sat":"10","status":"ok"}
  
  {"ip":"xxx.xx.xx.xxx","power":"7.15","sat":"10","capacity":"20","status":"ok"}
  </code></pre>
  
  <p>Now i have created 1 trigger in which i am getting this data. now i want to split data and want to get value of <code>capacity</code> . </p>
  
  <p>This <code>capacity</code> position is not fixed and may be sometime it will not come with data.</p>
  
  <p>So how can i split and get value of <code>capacity</code> ? .I have SQL SERVER 2008.</p>