Administer > Database administration > Data persistence > Queries > Complex query expressions

Complex query expressions

Service Manager offers several methods to perform complex queries. These include:

  • Logical operators, such as AND, OR, and NOT
  • Relational Operators, such as greater than, less than, and equal to
  • RAD functions, such as index() and tod()
  • IR Expert searches

Related topics

Logical operators
Relational operators
Wildcard characters
IR Expert
Retrieving records using the Query window method
The Database Manager utility
Simple query expressions

Create a query using not in statements
Perform IR Expert queries
Use like queries to search for a string of characters
Use the index function in a query
Use the lng function in a query
Use the tod function in a greater than or less than query

Service Manager Programming