title: SQL syntax to look for a specific figure among a number in Teradata
body: <p>I'm looking for, how to search for a specific digit inside a numeric column in Teradata. I managed to do it for char type with </p>
  
  <pre><code>SELECT * from Table WHERE CharColumn LIKE ('%SearchedChar%')
  </code></pre>
  
  <p>but it doesn't seem to work with numeric values.
  Thanks for your help.</p>
  
  <p><strong>EDIT</strong> :<br>
  I need this because i'm coding a .NET function to generate teradata queries from what a user types in a textbox.</p>