Multiple object filter criteria

Toad for SQL Server
1

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

2

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?