I’m trying to figure out to lookup values with “CONTAINS” statement and using multiple conditions.
Here are some examples:
Lookup table has the following values:
Col 1 Return Val
COLUMBUS, OH CL1
COLUMBUS, GA CLGA
Main table has the following columns:
The problem is that lookup table has optional state while it is always present in the main table, so I’m not sure how to perform correct lookup.