No, you're not missing something, that is what was originally described as to-do. @MichaelC: the update statement with the case in it seems syntactically correct, but it updates ALL rows in the table, ...