I think this should be pretty easy for someone to answer. I'm trying to clean up our data a bit and I have an update query that doesn't seem to be updating all the rows I thought it would. The second I add multiple INs to the WHERE clause, it updates far fewer rows than I would expect. When I refresh a report based on this data, there are still records with incorrect data I was trying to update.
SET Style = 'CARPET CLEANING - IN-PLANT', Pr_Code = '92'
WHERE Pr_Code IN ('91', '92') AND JobCostDate <= '20020101' AND Style IN
('BROT-IN CLEANING', 'IN-PLANT CLEANING G','IN-PLANT CLEANING P',
'IN-PLANT CLEANING S', 'PICK-UP CLEANING', '1N-PLANT CLEANING G',
'.N-PLANT CLEANING S', '1I-PLANT CLEANING S', '1N-PLANT CLEANING G',
'CARPET CLEANED', 'CARPET CLEANING', 'CLEAN');