Joined: 05 Feb 2007 Posts: 199 Location: Sri Lanka
The CASE that you have used inside a SELECT statement, is a CASE expression. This is not the CASE procedural statement where ';' is needed at the end of THEN.
And, when you use CASE expressions, the thing that follows a THEN or ELSE is a result-expression containing arithmatic, date or other such operands. Not a statement like SELECT or UPDATE.
When you say that you have seen CASE with THEN followed by UPDATE, those must have been CASE procedural statements. But even in procedural CASE statements, the only SELECT that is allowed is a SELECT INTO(not a normal SELECT).