SQLTeam.com | Weblogs | Forums

Conversion failed when converting the varchar value 'F' to data type int


#1

Msg 245, Level 16, State 1, Line 2
Conversion failed when converting the varchar value 'F' to data type int.

I'm trying to query all records and I get this error.

ADP####S or ADP####F is causing the problem but not able to get it resolved.


#2

most probably you are querying a table as follows

select * from persons where roomnumber = 6

instead of
select * from persons where roomnumber = '6'

because roomnumber is not int datatype column