title: DataTable - Select only find row where value is less than 10?
body: <p>I'm having a really hard time trying to figure out what's going on with the Select method of DataTable. Here's the data that I got back in a DataTable, called <code>VotePeriods</code>:</p>
  
  <p><code>PeriodID</code> <code>Description</code></p>
  
  <p><code>11</code> <code>Test 11</code></p>
  
  <p><code>10</code> <code>Test 10</code></p>
  
  <p><code>9</code> <code>Test 9</code></p>
  
  <p>...</p>
  
  <p>...</p>
  
  <p><code>1</code> <code>Test1</code></p>
  
  <p>Here's the code to select the period based on PeriodID:</p>
  
  <pre><code>if (VotePeriods.Rows.Count &gt; 0)
  {
      DataRow[] vp = VotePeriods.Select("PeriodID = " + voteperiod);
  
      if (vp.Length &gt; 0)
      {
          return vp[0];
      }
  }
  </code></pre>
  
  <p>For some reason, if <code>voteperiod</code> is 9 or less, then I have the correct row selected. But if I pass in a <code>10</code> or <code>11</code>, I have no data back, even though in my DataTable, PeriodID <code>10</code> and <code>11</code> exists. Any suggestion?</p>
  
  <p>Thanks.</p>