String Functions

A string is any sequence of characters. The following values can all be treated as strings:

myStrings

Jack Jones

123

true

NY

Tip: Any value can be a string. So, you can change the data type of any column to string to use these functions. In some cases, however, it is easier to use other functions that are designed for the original data type. Make sure you switch the type back after completing your string manipulation.

String functions perform operations on text data. Based on column or string literal inputs, these functions render outputs that provide a subset of the input, convert to a different format or case, or compute metrics about the input. These functions are very useful for manipulating strings.