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 predicate syntax of the DBMS 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.