title: Comparing two character values in a Coldfusion cfquery
body: <p>I have a database field which contains <code>VARCHAR</code> values like</p>
  
  <pre><code>XY23(CX Web)
  </code></pre>
  
  <p>AND I am writing a Query of Queries like</p>
  
  <pre><code>SELECT qPdfs.filename, qPdfs.code, qObjects.id
  FROM qPdfs, qObjects
  WHERE qPdfs.code = qObjects.code
  </code></pre>
  
  <p>OR like</p>
  
  <pre><code>SELECT qPdfs.filename, qPdfs.code, qObjects.id
  FROM qPdfs, qObjects
  WHERE &lt;cfqueryparam value="#qObjects.code#" cfsqltype="CF_SQL_VARCHAR"&gt; = &lt;cfqueryparam value="#qPdfs.code#" cfsqltype="CF_SQL_VARCHAR"&gt;
  </code></pre>
  
  <p>But I am getting an error message like</p>
  
  <pre><code>XY23(CX Web) must be interpretable as a valid number in the current locale.
  </code></pre>
  
  <p>Any help?</p>
  
  <p>Thank you</p>