I have a report that goes and does a sort of field validation/quality assurance check.<BR><BR>Basically it runs a bunch of sub queries and shows a summary report.<BR><BR>If something is not as it ...

The CASE expression selects values if certain conditions are met. A CASE expression returns a single value that is conditionally evaluated for each row of a table (or view). Use the WHEN-THEN clauses ...

operand is one of the following: constant is a number or a quoted character string (or other special notation) that indicates a fixed value. Constants are also called literals. Constants are described ...