coalesce(arg1,arg2,...,argN)
returns the value of the first of its input parameters that is not NULL
Accept Type(s): Arguments can be of any type, given that the argument count is more than zero and all the
arguments are of the same type.
split(sourceText, splitCharacter, returnedOutputPosition)
Splits the source String by splitCharacter and return the string in the index given by returnedOutputPosition​ ​
Accept Type(s): (STRING, STRING, INT)
Return Type(s): STRING
substr(sourceText, beginIndex) or substr(sourceText, beginIndex, length) or substr(sourceText, regex)
or substr(sourceText, regex, groupNumber)
Returns a new string that is a substring of this string.
unhex(str);
This is the equivalent of 'unhex' function in mysql 5.0
unhex(str) interprets each pair of characters in the argument as a hexadecimal number
and converts it to the byte represented by the number.