Text
Text functions (reference)
Function | Description |
---|---|
LOWER | Converts all characters in a supplied text string to lower case
|
UPPER | Converts all characters in a supplied text string to upper case
|
TRIM | Removes duplicate spaces, and spaces at the start and end of a text string
|
LEFT | Returns a specified number of characters from the start of a supplied text string. example
|
MID | Returns a specified number of characters from the middle of a supplied text string
|
RIGHT | Returns a specified number of characters from the end of a supplied text string
|
FIND | Returns the position of a supplied character or text string from within a supplied text string (case-sensitive).
|
LEN | Returns the length of a supplied text string
|
Last updated