Toad World® Forums

Multiple object filter criteria

In setting a filter for the Object Explorer | Filter Tables, either quick or named, is there a way of specifying more than one criterion?
E.g. LOWER(obj.name) LIKE ‘AA%’ OR LOWER(obj.name) LIKE ‘AB%’

Thanks in advance,

-ATT

Hi Justtodd,

I have a feeling you are talking about custom filter, go to filter window, SQL tab, check “enable custom SQL”, copy filter from your post into the editor area on that tab.
Now you can preview your filter (PREVIEW tab) or use it straight away.

Did it answered your question?