SQLTeam.com | Weblogs | Forums

Error converting data type varchar to bigint


#1

Error converting data type varchar to bigint. wat this error mean.... i hav checked all the input parameter.. the parameters are fine.... thn y tis error appear while i m executing... pls add me a solution... y tis prob occur and a solution fr tis error


#2

Your data has a value that cannot be converted. Since you did not show the query or error it is hard to know exactly what the problem is. Is this an implicit or explicit conversion?

Please provide the code and table definitions.


#3

You can check the data for non-digits using the code:

SELECT *
FROM dbo.table_name
WHERE column_to_be_converted LIKE '%[^0-9]%' --non-digit