In a limited number of situations, even the advanced filter does not offer the flexibility needed to make the precise selection. In that case, you have the possibility to choose the option Show SQL in the View menu of the Advanced database filter window. The following screen will be shown:
In this window, you can define your filter conditions using the SQL of the connected database. By default, you will see the SQL equivalent of the conditions defined in the standard view of the advanced filter, but you can change it the way you want. The SQL you enter will be stored in the internal database, but will be lost if you switch back to the standard view. In that case, you will see the conditions as you defined them before activating the Show SQL option.