iif statement help needed for logical expression

[mpreziosi]

I am using GM Premium 8.03, creating iif statement for the lookup.ini file. I have a list of 3 character codes to evaluate, and depending on which of these appears in the key4 field, i need to enter certain text in the Mergecodes field. I'm having trouble with "OR", adding more than one value in the logical expression.
For example the first one works, the second one returns nothing. How can I get a list of 6 different 3-character codes into this statement?
[Mergecodes]
Otherwise = &iif(left(Key4,3) = "ABT", "Tech", "") works fine

Otherwise = &iif(left(Key4,3) = "ABT" OR "MET" OR "GED"
or TOR" or "FRR" or "LKJ", "Tech", "") doesn't work

 

[goner]

Use a CONTAINS expression like this:

Otherwise = &iif(left(Key4,3) $ "ABT MET GED TOR FRR LKJ", "Tech", "")

Doug Castell
Castell Computers

http://www.castellcomputers.com

 

[mpreziosi]

thank you Doug! That works great!!