>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

The original problem is because he used AddWithValue and the parameter was send as varchar. If he would use Add and exact type, this would not happen.

BTW, this works

SELECT CAST( 123.45 AS INT)