Error converting data type varchar to int error? can anyone tel me the reason for this error

Question

during inserting values from ASP page to SQL 2000

Answer 1

You can't convert strings to integers if they are not made entirely from numbers.

So, if you try to convert aaa to an int, this will fail. If you try to convert the varchar 123 to an int, it will work.