title: Using cast in insert statement
body: <p>I am inserting some raw data into a table in MS SQL 2005 from excel.
  Some of these data are not formatted correctly ie the amount colum is formatteT as a number 12345 whereas i need to be like 123.45 so i use this 
  <code>CAST(TRANSACTION_HISTORY.AMOUNT  AS decimal) / 100</code> 
  to convert it correctly.
  However is there a way to use the cast in an insert statement??</p>
  
  <p>thanks</p>