# The operators

The following table lists the operators available in basic mode.

| Operator | Example | Details |  |
| --- | --- | --- | --- |
| Type | Name |  |  |
| Text | is | CustomerName<br>is<br>Smith | - |
| is<br>not | FirstName<br>is not<br>John | - |  |
| contains | StatusCode<br>contains<br>0AZ | - |  |
| does not<br>contain | ItemID<br>does not contain<br>X32 | - |  |
| starts<br>with | BankNumber<br>starts with<br>FR | - |  |
| does not start<br>with | ItemID<br>does not start with<br>DE123 | - |  |
| ends<br>with | BankNumber<br>ends with<br>0089 | - |  |
| does not end<br>with | BankNumber<br>does not end with<br>Y9 | - |  |
| matches<br>regex | PostalCode<br>matches regex<br>^[0-9]{5}(-[0-9]{4})?$ | - |  |
| does not match<br>regex | SSN<br>does not match regex<br>^\\d{3}-\\d{2}-\\d{4}$ | - |  |
| is of<br>type | Location<br>is of type<br>Asia | Select a semantic type or standard type: boolean, date, decimal or<br>integer. |  |
| is<br>empty | DriverLicense<br>is empty | - |  |
| Number | is equal<br>to | Age<br>is equal to<br>21 | - |
| is not equal<br>to | CustomerID<br>is not equal to<br>16742 | - |  |
| is greater<br>than | Age<br>is greater than<br>17 | - |  |
| is greater than<br>or equal to | Age<br>is greater than or equal<br>to<br>21 | - |  |
| is less<br>than | Age<br>is less than<br>16 | - |  |
| is less than or<br>equal to | Age<br>is less than or equal to<br>20 | - |  |
| Date and time | is equal<br>to | DateOfReceipt<br>is equal to<br>2020-05-14<br>09:55:00 | You can select a date or a time, or both.<br><br>The supported<br>formats are:<br><br><ul> <li>yyyy-mm-dd,</li> <li>hh:mm:ss,</li> <li>yyyy-mm-dd hh:mm:ss.</li> </ul> |
| is not equal<br>to | ValidationDate<br>is not equal to<br>2020-09-02 |  |  |
| is<br>before | BirthDate<br>is before<br>2003-12-16 |  |  |
| is before or<br>equal to | ExpiryDate<br>is before or equal to<br>2002-01-01 |  |  |
| is<br>after | BirthDate<br>is after<br>1983-12-31 |  |  |
| is after or<br>equal to | BirthDate<br>is after or equal to<br>1971-01-01 |  |  |
| is in<br>(month) | HireDate<br>is in month<br>March | - |  |
| is on (day of<br>the week) | PublicationDate<br>is on day of the week<br>Friday | - |  |
| is on (day of<br>the month) | PublicationDate<br>is on day of the month<br>16 | - |  |
| Boolean | is<br>true | Validity<br>is true | - |
| is<br>false | Validity<br>is false | - |  |
| is equal to | Access<br>is equal to<br>Validity | These operators allow you to compare two variables of<br>boolean type. |  |
| is not equal to | Access<br>is not equal to<br>Validity |  |  |