title: SQL teradata trying to obtain all rows where column has a question mark
body: <p>I have a column(dt) that either contains a date (mo/dd/yr) or a question mark(?). In my where close I'm trying to select only rows where the column has a question mark. I tried the following below and I get an error.   </p>
  
  <pre><code>where c.dt = '?'   
  </code></pre>
  
  <p>The error I get is: <code>SELECT Failed. 3535:  A character string failed conversion to a numeric value.</code></p>