title: SQL Server - Error converting data type float to bigint
body: <p>Can the datatype of a field be changed to bigint from float ??</p>
  
  <p>Create a new column that's an integer:</p>
  
  <pre><code>ALTER TABLE tabl ADD newCol int;
  </code></pre>
  
  <p>Select the data from the old column into the new one:</p>
  
  <pre><code>UPDATE tabl SET newCol = CAST(TEL2 AS int) FROM tabl ;
  </code></pre>
  
  <p>P.S: I am using MS SQL Server</p>
  
  <p>i try to us this in c# but it didn't get any result</p>
  
  <pre><code>  string sqlCommand = "SELECT * FROM tabl WHERE CONCAT([TEL1], [TEL2],[TEL3], [TEL4],[TEL5], [TEL6],[TEL7], [TEL8],[TEL9]) LIKE '%" + txtBoxSearch.Text + "%'";
  </code></pre>
  
  <p><strong>I store telephone numbers as float and try find it by the c# code and didn't get any result so im trying to convert the column or correct the c# code</strong></p>