These functions operate on string values. Some of them return strings and others return numeric values.

Format - embed numeric or string values within a string using formatting codes

FormatDate - convert a date to a string in any format

Left - get the left end of a string

Length - get the number of characters in a string

Match - see if a string matches a pattern

Mid - extract part of a string

Replace - replace text wherever it is found in a string

Right - get the right end of a string

ToDate - parse a string and return a date value

ToLower - convert a string to lowercase

ToNum - find a number within a string

ToUpper - convert a string to uppercase

Copyright © 2020-2025 Systematic Solutions, LLC