Jump to content

Case statement with multiple "when" entries

christopher sawtelle 2

Recommended Posts

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



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




Both lines work when they are the only one.


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

Link to comment
Share on other sites

  • 2 years later...
  • 3 years later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...