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
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
|