Very new to SQL and relying on google but can't find a good reason why I am getting this error. Trying to update a record with a WHERE clause but I keep getting this error and the "QRT-S534" has nothing to do with my UPDATE statement.
Msg 245, Level 16, State 1, Line 1
Conversion failed when converting the varchar value ' QRT-S534' to data type int.
UPDATE IM_ItemWarehouse SET QuantityOnHand = 12 WHERE ItemCode = 25688