... where inlist(Status, "A", "F", "T", "H", "E", "W") >Hi > >I have a large table with a status field and I want to select the records for a group os status's. >the table is indexed on the status > >this can be done by ><pre>lcStatusList = 'AFTHEW' >SELECT* ; >FROM mytable ; >WHERE mytable.status $ ?lcStatusList>
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'>