Text Functions

On this page, you'll find the most commonly used text functions, each demonstrated in a simple example.

Text Functions

CONCATENATEJoin values, one after another
LEFTExtract characters starting from the left
LOWERConvert to lowercase
MIDExtract characters from a string
PROPERConvert the first letter of each word to uppercase and the other letters to lowercase
RIGHTExtract characters starting from the right
UPPERConvert to uppercase