@MichaelC: the update statement with the case in it seems syntactically correct, but it updates ALL rows in the table, not just those where the condition is met.