>>
>>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)

>
>Well there you go. It occurred to me last night that perhaps the original code would work if I did this:
>

>oCommand.Parameters.AddWithValue("@AmendmentNumber", Val(Amendments_DDL.SelectedValue))
>

>And sure enough it does.
>Thanks to all.

I don't recommend to use AddWithValue as I already said. AddWithValue is a quick way and it often leads to troubles. I suggest to always be explicit and use Add syntax and exact type instead. It also helps to document and requires more strict programming.