title: Select from either a list or select all the values in SQL
body: <p>SQL Server question -
  I am trying to fetch some records from lets say a table named BUDGET. The filter used is Cost Center (CostC).
  I have created the query such that if there are mutiple CostC, then it will be</p>
  <pre><code>select costc,description,budget from BUDGET where costc IN ('c1',c2',c3')
  </code></pre>
  <p>But I also need a feature so that, in case there is no list, then the filter on COSTC should look for all (*) cost centres.</p>