SQL - The OR in the when clause error

Jul 02, 2019 SQL - The OR in the when clause error

SQL, SQL Server July 02, 2019

This is a common error when you are attempting to use an OR to satisfy multiple conditions in a WHEN statement. "The OR in the WHEN clause of a CASE statement is not supported."

Consider this SQL which currently gives the "The OR in the WHEN clause of a CASE statement is not supported" error:

CASE ebv.db_no 
    WHEN 22978 OR 23218 OR 23219 THEN 'WECS 9500' 
    ELSE 'WECS 9520' 
END as wecs_system

Solution 1:

CASE ebv.db_no 
  WHEN 22978 THEN 'WECS 9500' 
  WHEN 23218 THEN 'WECS 9500'  
  WHEN 23219 THEN 'WECS 9500' 
  ELSE 'WECS 9520' 
END as wecs_system

Solution 2:

CASE  
  WHEN ebv.db_no IN (22978, 23218, 23219) THEN 'WECS 9500' 
  ELSE 'WECS 9520' 
END as wecs_system

admin API array async Birthday BookGuide Button bytes c# c# enum to int c# int to enum c# int to string c# iterate dictionary c# loop through dictionary c# outofmemoryexception c# run as admin C++ cast cheatsheet CLASSPATH compare convert int to string Dad Dictionary editor enum exception exit Fathers Day for for loop foreach generic Gift gift guide Git global Guide HTML INNER JOIN int iterate Java java.lang.OutOfMemoryError Javascript jQuery JSON KnockoutJS list loop MERGE nested loop outofmemory PHP PHP Redirect PowerShell programmer gift programmer mugs programmer shirts programmer stickers python python bytes to string python external command python for loop python int to string quit random Redirect repr() shell command SQL SQL Server STDIN STDOUT str() string switch system.outofmemoryexception c# systemoutofmemory type UPDATE variables vi vim _

SQL - The OR in the when clause error

Back to The Programmer Blog

shop

2024

2023

2020

2019

2018

2017