title: Delphi 7 - error when get values using sql operator in
body: <p>Got no answer on related thread, so i make this question. I've been searched for how to retrieve records value using where clause with multiple values and i got this.</p>
  
  <p>table example :</p>
  
  <pre><code>|ID |PRICE|
  |1  |3000 |
  |2  |2000 |
  |3  |1000 |
  |4  |5000 |
  |5  |4000 |
  </code></pre>
  
  <p>SQL query :</p>
  
  <pre><code>DM.Zread.Close;
  DM.Zread.SQL.CommaText := 'select PRICE from DVD where ID in (1, 2, 3)';
  DM.Zread.Open;
  </code></pre>
  
  <p>Above gave me an error, when i only put one 1 values which is (1) or (2) it's works fine.</p>
  
  <p>Questions are :</p>
  
  <ol>
  <li>how to straight it, so i could get the values from 3 different
  records ? </li>
  <li>how to apply it on string values instead ?</li>
  </ol>