title: HOW TO query multi-valued column by key in SQL SERVER
body: <p>How to query a <code>multivalued</code> column for a specific key?</p>
  
  <p>Sample Data</p>
  
  <pre><code>ID   DAY              PRICE
  1    01;02;03;04;...  100;230;110;34.5;...
  2    01;02;03;04;...  120;240;510;34.5;...
  </code></pre>
  
  <p>For example: </p>
  
  <p>select ... where DAY key = '02'</p>
  
  <p>Expected:</p>
  
  <pre><code>ID DAY PRICE
  1  02  230
  2  02  240
  </code></pre>
  
  <p><strong>Notes</strong></p>
  
  <p>The actual table has over 30 fields. </p>
  
  <p>Joining multiple <code>CROSS APPLY SPLIT_STRING</code> looked like a tedious solution</p>