Page 1 of 1

[SOLVED] IN clause not working as expected

Posted: Thu May 17, 2007 5:52 am
by impulse()
Can anybody see why the following query is only updating the first row inside the IN clause:

Code: Select all

UPDATE table
SET column = '999'
WHERE product IN ('a', 'b', 'c')
I'm having a clueless day today where errors don't make sense.

Posted: Thu May 17, 2007 7:06 am
by impulse()
Dam Microsoft SQL server. They have to be arkward :)