title: select from string field , separated SqlServer
body: <p>I have table1 that has field contains value separated with ','    </p>
  
  <pre><code> name           value
  --------------------------
      test           1,2
      flower         3
      car            4,2
      dog            2
  </code></pre>
  
  <p>I want select command that finds rows contain specific value in this column</p>
  
  <p><code>string @value = 2</code></p>
  
  <p><code>select * from table1 where ?</code></p>
  
  <pre><code> name           value
  --------------------------
      test           1,2
      car            4,2
      dog            2
  </code></pre>