Write a Where Clause

Writing Where Clauses can be complicated, so the Where Clause Builder can help. A Where Clause can be based on almost any field in the Personal, Contract or Payroll tabs.

To write a Where Clause:

  1. Enter the field name you want to reference.

  2. Enter the value of the field in single quotes or apostrophes. For example, TheDepartment = "Finance" will find employees who have Finance set in the Department field on their Contract tab.

Where Clause tips

  • In a Where Clause, the field name usually needs to be preceded by "The"

  • The value you're testing for must be entered in exactly the same way as it's written in your system.
    For example, if you have a department called Sales & Marketing, entering TheDepartment = "Sales and Marketing" won't return any matching employees because "and" has been used in the Where Clause rather than "&".

  • Where Clauses are not case-sensitive. Entering thedepartment = 'finance' still returns any employees whose department is set to "Finance"