title: INSERT INTO number value with comma thousand delimiter
body: <p>My SQL is</p>
  
  <pre><code>"INSERT INTO table1 (Item, Price) VALUE ('" &amp; ItemString &amp; "', " &amp; PriceValue &amp; ")"
  </code></pre>
  
  <p>It works fine.  But, if price is <code>12,345.67.</code>  SQL error message is</p>
  
  <p>Number of Query Values and Destination Fields are not the same.</p>
  
  <p>It is because the value thousand comma delimiter. How should I modify my <code>SQL</code> to let the number value has comma delimiter (and possible $ sign)?</p>
  
  <p>Thanks in advance.</p>