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 ...

Some DBMSs allow case sensitive column and table names as well as names with special characters such as an Oracle column named Amount Budgeted$. Therefore, special consideration should be used when ...