Working with CASE
Duration: 10 to 15 minutes.
In this exercise you will practice using
- Create a report that shows the company names and faxes for all customers. If the customer doesn't have a fax, the report should show "No Fax" in that field as shown below.
WHEN Fax IS NULL
THEN 'No Fax'