title: sql select string between two strings in a column
body: <p>I have a table for example - TABLE. In the table is column name - CUSTOME_FIELDS. in this column I have data like this:</p>
  
  <pre><code>{"6":"Name of company","1":"11111111","2":"564974195","4":"","5":"","3":""}
  </code></pre>
  
  <p>I need to take - Name of the company - and give it to new column - NEW_COLUMN.</p>
  
  <p>How can I do that? I tried something like this:</p>
  
  <pre><code>SELECT SUBSTRING(CUSTOME_FIELDS, CHARINDEX('"6":"', CUSTOME_FIELDS), CHARINDEX('","1"',CUSTOME_FIELDS)) FROM TABLE
  </code></pre>
  
  <p>but it doesn't work.</p>