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
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