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