(IF) Statement With Number Range

[MalcolmCICWF]

I have a list of codes 1000-5000. I want to load codes 2000-3500 as "Label". How could I write this out without doing a Mixmatch and listing all the codes I want or do not want? I believe it is some sort of "IF" statement, but I am not sure how to write it out.

[MayilVahanan · Accepted solution]

HI

Try like this

Load *,

If(Codes >=2000 and Codes<=3500,Codes) as Label from tablename;

Hope it helps