# The operators

Available in...

* Cloud API Services Platform
* Cloud Big Data
* Cloud Big Data Platform
* Cloud Data Fabric
* Cloud Data Integration
* Cloud Data Management Platform
* Cloud Pipeline Designer Standard Edition
* Data Fabric

The following table lists the operators available in basic mode.

List of operators with examplesList of operators with examples

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