1 Reply Latest reply on Mar 16, 2011 10:13 AM by philmodjunk

    case statement for range between values

    kilbot

      Title

      case statement for range between values

      Post

      Sure I'm doing something wrong, might be half right

      trying to write a case statement for a range

      case(

      UNIT_CODE = 0001 & "..." & 0102; "Dist 01")

      So if the value in UNIT_CODE is 1 all the way to 102 it will show Dist 01

      Thanks