lcStatusList = 'AFTHEW' SELECT* ; FROM mytable ; WHERE mytable.status $ ?lcStatusListUnfortunately, this does not optimize.
SELECT* ; FROM mytable ; WHERE mytable.status = 'A' OR ; mytable.status = 'F' OR ; mytable.status = 'T' OR ; mytable.status = 'H' OR ; mytable.status = 'E' OR ; mytable.status = 'W'regards