Optimizing MEMBER OF with APEX_STRING.SPLIT

apex_string.split is a great utility that allows you to take a delimited list and make it queryable. Here's a small example: select column_value from apex_string.split('John,Sally,Bob', ',') ; COLUMN_VALUE _______________ John Sally Bob You can ...