| Text Functions |
Description |
|---|---|
| CONCATENATE | Used to join as many as 255 text strings into a single text string |
| LEN | Returns the number of characters in a string |
| Rounding Functions | |
| LEFT | Returns the number of characters you specify from the left side of a string. |
| MID | Returns the number of characters you specify from a string starting at the position you specify |
| RIGHT | Returns the number of characters you specify from the right side of a string |
| Change the Case of a String | |
| LOWER | Converts a string to all lowercase letters |
| UPPER | Converts a string to all uppercase letters |
| PROPER | Capitalizes the first letter in a string and all other letters that follow any character other than a letter. All other characters in the string are converted to lowercase letters |
| Find a String within another String | |
| FIND | Returns the starting position of where one string is found in another string. It is case sensitive. |
| SEARCH | Returns the starting position of where one string is found in another string. It is not case sensitive. You can use wildcards in the search string. |
| Replace Part of a String with another String | |
| REPLACE | Replaces part of a text string with a different text string |
| SUBSTITUTE | Replaces existing text with new text. |