title: Select Failed in Teradata
body: <p>I have SSN column varbyte(100) in TableA.</p>
  
  <p>It has data in hexadecimal ,
  ex : 9C-B2-EE
       .
       .</p>
  
  <p>when i wrote</p>
  
  <pre><code> sel * from TableA where ssn='9C-B2-EE'
  </code></pre>
  
  <p>SELECT Failed: 3640: Comparing BYTE data in column SSN with other types is illegal</p>
  
  <p>When I wrote </p>
  
  <pre><code> sel * from TableA where ssn='9C-B2-EE'xb
  </code></pre>
  
  <p>SELECT Failed: 3775: Invalid hexadecimal constant.</p>
  
  <p>When I wrote </p>
  
  <pre><code> sel * from TableA where ssn='9C-B2-EE'xc
  </code></pre>
  
  <p>SELECT Failed: 3775: Invalid hexadecimal constant.</p>
  
  <p>Can any one help how to use ssn in where ?
  Thanks.</p>