Text functions manipulate Text values and return other Text values. The length of the resulting Text value depends on the lengths of the arguments, and the operations performed. Typically, you use Text functions to perform operations like substring extraction, pattern matching, and composite-key construction.
If you assign a Text value to a shorter field, the Text will be truncated.
In this section: