Null in case expression

See more:

MySQL

In the customers' table, many customers do not have state data in the state column therefore when we select customers, the state column displays NULL values, which is not meaningful for the reporting purpose.

customerNumber   customerName         state   country
 103           Atelier graphique       NULL    France 
112           Signal Gift Stores        NV      USA

I am trying to improve the output by using the case, but getting an error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' THEN 'N/A' ELSE state END) as state, country FROM customers' at line 5"

What I have tried:

<pre>SELECT 
    customerNumber,
    customerName,
    STATE 1= ( CASE State
When NULL Then'N/A'
ELSE state
			 END),
    country
FROM
    customers;