EQL supports the following string functions.
CONCAT function
CONCAT
is a row function that returns a string that is the result of concatenating two or more string values. Its syntax is:
CONCAT(string1, string2 [, stringN])
Each argument can be a literal string (within single quotation marks), an attribute of type string, or any expression that produces a string.
RETURN results AS SELECT CONCAT('Jane ', 'Amanda ', 'Wilson') AS FullName FROM EmployeeState GROUP
RETURN results AS SELECT ARB(CONCAT(CUST_FIRST_NAME, ' ', CUST_LAST_NAME)) AS CustomerName FROM EmployeeState GROUP
SUBSTR function
SUBSTR
function has two syntaxes:
SUBSTR(string, position) SUBSTR(string, position, length)where:
Note that position is not zero indexed. For example, in order to start with the fifth character, position must be 5.
TO_STRING function
TO_STRING
function takes an integer value and returns a string equivalent. Its syntax is:
TO_STRING(int)
If the input value is NULL, the output value will also be NULL.
RETURN results AS SELECT ARB(TO_STRING(P_SIZE)) AS Sizes FROM ProductState GROUP