Don,

Exactly as Charles said, you want to round the number to get rid of decimals. The integer data type is constrained to only store whole numbers.

Just to demonstrate in SSMS: This won't work...

SELECT CAST( '123.45' AS INT)  -- GENERATES AN ERROR

But this will work:

SELECT CAST(  ROUND('123.45',0) AS INT)   -- GENERATES 123