title: Using "CAST" operator in sql with where and IN clause not working
body: <p>The right query that works fine is </p>
  
  <pre><code> select * from Pretty_Txns where Send_Customer in   ('1000000000164774783','1000000000253252111')
  </code></pre>
  
  <p>But I have data coming from outside SQL from a python application which is of the below format and of a varying length and hence the use of <strong>IN</strong> clause as it can be easily parameterised</p>
  
  <pre><code>  (1000000000164774783,1000000000253252111)
  </code></pre>
  
  <p>So , I am trying to use a <strong>CAST</strong> operator to make life simple </p>
  
  <pre><code>    select  * from Pretty_Txns where cast (Send_Customer as numeric) in(1000000000164774783,1000000000253252111) 
  </code></pre>
  
  <p>But it fails with:</p>
  
  <pre><code>    Arithmetic overflow error converting varchar to data type numeric.
  
      select  * from Pretty_Txns where cast (Send_Customer as bigint) in(1000000000164774783,1000000000253252111) 
  
      Error converting data type varchar to bigint.
  </code></pre>