You are here: All Help Topics > Accounting and Assurance > Calculations, Functions and Linkages > Text functions
-- Reference --

Text Functions

Use text functions to make the database filters more flexible and specific.

 

Function Description

IN

Evaluates the position of string value 1 within value 2.

LEFT

Selects a specified number of characters starting from the leftmost character of a character expression.

LOWER

Converts the string to lower case.

LTRIM

Trims any leading spaces from a string of text.

MID

Returns value 2 characters of a string starting at position value 1 of the string.

RIGHT

Selects the right most specified number of characters of a character expression.

SCANSTR

Evaluates the position of one string value within another string value.

SUBSTR

Selects a portion of a string to display.

TRIM

Trims any trailing spaces from a string of text.

UPPER

Converts the string to upper case.

Note

  • The maximum length for a database filter is 200 characters.
  • For using dates in a filter, see Date Fields for more information.