title: Multiple Filter in the same column
body: <p>I have a sql table with some values and a lot of filters </p>
  
  <pre><code>ID | Name  | Filter1 | Filter2 | Filter3 | Filter4 ... and so on...
  </code></pre>
  
  <p>As now the filters have been set as int and I am running a query as follows to get the data required</p>
  
  <pre><code>select Name 
  from tblABC 
  where Filter1=1 and Filter2 = 7 and Filter3 = 33 ... and so on...'
  </code></pre>
  
  <p>My issue is that I want a filter column to hold multiple numbers. eg:- row no 3 will have numbers 8 and 13 in Filter1 cell, so that when I run a query for 8 or 13 I get the same result. 
  ie I want both the below queries to return the same result. </p>
  
  <pre><code>select... where  Filter1=8 
  select... where  Filter1=13 
  </code></pre>
  
  <p>How can this be done? I tried converting the Filter columns to nvarchar and entering data as .8.13. where '.' where was used as separators. After this, running a query 'select... where Filter1 LIKE '%.8.%' is working for me.. But there are like 12 Filter columns and when such a string search is run in large volumes, wouldn't it make the query slow. What would be a more efficient way of doing this?</p>
  
  <p>I am using Microsoft SQL 2014</p>