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