title: How to select on stored procedure with filter have more than 3 value
body: <p>I would like to know that how to select when using stored procedure with filter as combobox in website have more than 3 value</p>
  
  <p>Exp: I would like to select match listing. and filter is "IsFinish" with value (All, Yes, No)</p>
  
  <pre><code>DECLARE @IsFinish INT -- 1: All 2: Yes 3: No
  
  SELECT * FROM MATCH 
  WHERE [Status] = ?
  </code></pre>
  
  <p>Status values: F: Finished C: Canceled L: Live N: Non-Live P:Pause X:(Close) Waiting Confirm</p>
  
  <p>When select All the result will return all status.
  When select Yes the result will return F &amp; X.
  When select No the result will return N, L, C, P.
  I would like filter them by once select.
  How can I do it?</p>