Skip to end of metadata
Go to start of metadata
SQL Query OperatorDescription Information
String Operations
= 'string'String field exact match (Equals)

This is used for exact string matching

(warning) String fields must be enclosed in quotes

<> 'string'String field exact match (Not Equals)
LIKE '*string*'String field partial match (Equals Any Part of Field) wildcard(*) at start and end

The LIKE condition allows you to use wildcards in the where clause of an SQL statement.

This allows you to perform pattern matching

LIKE 'string*'String field partial match (Equals Start of Field) wildcard(*) at end
LIKE '*string'String field partial match (Equals End of Field) wildcard(*) at start
NOT LIKE '*string*'String field partial match (Not Equals Any Part of Field) wildcard(*) at start and end
NOT LIKE 'string*'String field partial match (Not Equals Start of Field) wildcard(*) at end
NOT LIKE '*string'String field partial match (Not Equals End of Field) wildcard(*) at start
Number Operations
= numberNumber field exact match (Equals)

This type of search is used for matching numbers. 

(warning) Number fields must NOT be enclosed in quotes

<> numberNumber field exact match (Not Equals)
>= numberNumber field range (Greater Than or Equals)
> numberNumber field range (Greater Than)
<= numberNumber field range (Less Than or Equals)
< numberNumber field range (Less Than)
Date & Time Operations
= #MM/dd/yyyy HH:mm:ss#Date/Time field match (Equals Date and Time)

This type of search is used for matching dates and/or date/time values.

(warning) Date and time fields must be delimited with the hash or pound symbol

 

> #MM/dd/yyyy HH:mm:ss#Date/Time field match (After Date and Time)
< #MM/dd/yyyy HH:mm:ss#Date/Time field match (Before Date and Time)

BETWEEN #MM/dd/yyyy HH:mm:ss# AND #MM/dd/yyyy HH:mm:ss#

Date/Time field match (Between Two Date/Times)
BETWEEN #MM/dd/yyyy# AND #MM/dd/yyyy#Date field match (Between Two Dates)
BETWEEN #yyyy-MM-dd# AND #yyyy-MM-dd#Date field match (ISO Format Between Two Dates)
Boolean Operations
= TRUEBoolean field exact match (True)This type of search is used to match fields where the condition is either TRUE or FALSE
<> TRUEBoolean field exact match (Not True)
= FALSEBoolean field exact match (False)
<> FALSEBoolean field exact match (Not False)
Record Ordering
ORDER BY <database field> ASCOrder Records by Field (Ascending)

This string can be added to the end of a query to sort the records in the returned query based on one or more fields.

The records can be sorted in ASCending or DESCending order.

ORDER BY <database field> DESCOrder Records by Field (Descending)
 Multiple Conditions
ANDThe AND operator displays a record if both the first condition and the second condition is trueThese operators can be used to create multiple conditions in the query
ORThe OR operator displays a record if either the first condition or the second condition is true