CASE WHEN

• Pass multiple values to case when expression

  May 28, 2019

  There may be a time when you want to pass multiple values to a CASE WHEN expression. Here’s an example, take this simple data set below:

  CREATE TABLE [Test]
  ([UserID]   INT, 
   [Approval] VARCHAR(10)
  );
  
  INSERT INTO [Test]
  VALUES
         (1, 
          'Reject'),
         (2, 
          'Approve'),
         (3, 
          'test'),
         (4, 
          'test2'),
         (5, 
          'Approve'),
         (6, 
          'Reject');
  
  SELECT 
         *
  FROM [Test];
  

  Our base data set we will use as an example.