Case statement with multiple "when" entries

[christopher sawtelle 2]

I am trying to write a case statement. If I do it as follows it works:

 

case when "13 3/8 IN" then 13.375

end

 

When I add multiple lines (whens) it errors (just says "the expression is not complete") such as:

 

case when "13 3/8 IN" then 13.375 when "10 3/4 IN" then 10.75

 

end

 

Both lines work when they are the only one.

 

I have not used the Case statement before so this is uncharted territory!

[christopher sawtelle 2]

Figured it out. Didn't need more than once ...

[Donald Johnson]

I like the form:

CASE [Variable]

WHEN 'Red' THEN 1

WHEN 'Blue' THEN 2

WHEN 'Yellow' THEN 3

ELSE 0

END