Case statement with other variable

• jmj

  SSC Enthusiast

  Points: 122

  More actions

  March 29, 2007 at 12:21 am

  #91084

  I have a case statement that was very straightforward

  CASE

  code

  WHEN '#' Then 'A'

  WHEN '$' THEN 'B'

  WHEN '%' then 'B'

  WHEN '2' Then 'A'

  WHEN '3' THEN 'c'

  WHEN '4' then 'B'

  ELSE ''

  End

  Now I've been asked to change it to add another vaiable, but just for one code.  All of them stay the same except when code is 2.

  If code 2 and LocationID is either '101','102','103' then it should be 'A'

  code 2 and LocationID is either '110','112','113' then it should be 'B'

  Is this possible?  Thanks, J

  '

• SwePeso

  SSC-Dedicated

  Points: 39757

  More actions

  March 29, 2007 at 1:55 am

  #697586

  CASE

  WHEN code= '#' Then 'A'

  WHEN code = '$' THEN 'B'

  WHEN code = '%' then 'B'

  WHEN code = '2' AND LocationID IN ('101', '102', '103') Then 'A'

  WHEN code = '2' AND LocationID IN ('110', '112', '113') Then 'B'

  WHEN code = '3' THEN 'c'

  WHEN code = '4' then 'B'

  ELSE ''

  End

   

  ---

  N 56°04'39.16"
  E 12°55'05.25"