title: Like operator with comma separated values using SQL query
body: <p>I have not able to getting my data using like operation</p>
  
  <p>below is my code</p>
  
  <pre><code>Declare @Search varchar(100)
  set @Search='Gender,Name,Age'
  select * from Table_SampleData where FieldName LIKE '%' +  @Search + '%'
  </code></pre>
  
  <p>I have my table data is like below</p>
  
  <p>Table_SampleData</p>
  
  <pre><code>FieldName   Values
  Gender       Male
  Name         Mazhar
  Age          31
  Location     Hyderabad
  </code></pre>
  
  <p>My output should be</p>
  
  <pre><code>FieldName   Values
  Gender       Male
  Name         Mazhar
  Age          31
  </code></pre>