AnsweredAssumed Answered

case statement for range between values

Question asked by kilbot on Mar 16, 2011
Latest reply on Mar 16, 2011 by philmodjunk

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

Outcomes