An SQL WHERE Clause can be used to select entries in a database, which meet a certain criterion.

1. Login into the application and choose Modify/Delete List in the main navigation menu.
   
2. Choose the user list, which you want to modify
3. In the groupbox Advanced List Properties confirm the checkbox to access advanced functions.
4. Define an SQL WHERE Clause. More information on SQL WHERE Clauses can be found here.
5. Click on Finish to confirm changes.

Example 1:

This example assumes, that your database has a column named "EmailAddress", which stores the email address. The following WHERE clause selects those entries, whose email address begins with "a".

WHERE EmailAddress LIKE 'a%'

Example 2:

This example assumes, that your database has a column named "Year", which stores the year when the user was born. The following WHERE clause selects those persons, who were born in 1966 and later.

WHERE Year>1965