title: cast varchar to float to bigint
body: <p>I am trying to cast varchar to bigint. Then inserting it into an int column. I found that I am not getting expected value. Then I tried the following statements:</p>
  
  <pre><code>DECLARE @varData VARCHAR(50)
  
  SET @varData  = '0000019.33'
  
  select cast(@varData *cast(100 as float) as bigint)
  
  select cast(@varData *cast(100 as float) as varchar)
  
  select cast(cast(@varData *cast(100 as float) as varchar) as float)
  </code></pre>
  
  <p>Results:</p>
  
  <pre><code>1932
  
  1933
  
  1933
  </code></pre>
  
  <p>I am not able to understand why this difference is coming. But when I change the value to <code>0000029.33</code> then there is no difference in results.</p>
  
  <p>I am stuck and do not have any idea why it's so happening. Help needed..!!!</p>