Compare range of values

[Greg G]

I'm trying to script a case statement that compares the value of a field to a set of numeric ranges to get a result. I am not having much luck with the syntax to define a range. I have tried the following so far:

CMSinglePhCalc ≤ "404" and CMSinglePhCalc > "320.5" ; "24"

and

CMSinglePhCalc = "404...320.5" ; "24"

Any ideas?

Thanks,

Greg

[mr_vodka]

Case ( CMSinglePhCalc ≤ 404 and CMSinglePhCalc > 320.5 ; 24 )