The Where Condition

 

Masks provide a filtering capability in the form of a user-definable Where condition.

For example, a Shuffle mask with a Where condition is shown below:

 

The text that you enter must be compatible with the SQL WHERE clause syntax of the database to which you are connecting.

You can omit the keyword 'WHERE' (the example above has omitted the keyword) or you can include it if you wish.