I'm trying to use a SELECT CASE to prevent dividing by zero. <BR><BR>Here's what I'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've tried rephrasing this a dozen time, but I always end up with: Syntax error (missing operator) in query expression. <BR><BR>Thanks.