I&#039;m trying to use a SELECT CASE to prevent dividing by zero.<BR><BR>Here&#039;s what I&#039;m trying to avoid:<BR><BR>SELECT *, (100*score/possibleScore) AS percentCorrect FROM ...<BR><BR>The problem occurs when possibleScore = 0!<BR><BR>So, why not:<BR><BR>SELECT *, CASE WHEN (possibleScore = 0) THEN (0 AS percentCorrect) ELSE (100*score/possibleScore AS percentCorrect) END FROM ...<BR><BR>? I&#039;ve tried rephrasing this a dozen time, but I always end up with: Syntax error (missing operator) in query expression.<BR><BR>Thanks.