String Aggregation Operators¶
String expressions, with the exception of
$concat, only have a well-defined behavior for strings of ASCII characters.
$concat behavior is well-defined regardless of the
For details on specific operator, including syntax and examples, click on the specific operator to go to its reference page.
||Concatenates any number of strings.|
||Returns a substring of a string, starting at a specified index position up to a specified length. Accepts three expressions as arguments: the first argument must resolve to a string, and the second and third arguments must resolve to integers.|
||Converts a string to lowercase. Accepts a single argument expression.|
||Converts a string to uppercase. Accepts a single argument expression.|
||Performs case-insensitive string comparison and returns: