Apollo SQL > String Functions

Apollo SQL currently supports the following string functions:

Copy	Returns a substring of a string.
Extract	Returns the year, month, or day field from a DATE column.
Format	Formats the series of arguments in the list of arguments Arg1, Arg2, Arg3, ....
FormatDateTime	Formats the date-and-time value given by DateTime using the format given by Format.
FormatFloat	Formats the floating-point value given by Value using the format string given by Format.
Left	Returns the leftmost Count characters contained in a string.
Length	Returns the number of characters actually used in a string.
Lower	Returns a string with the same text as the string passed in, but with all letters converted to lowercase.
Pos	Searches for a substring within a string.
Right	Returns the rightmost Count characters contained in a string.
SubString	Extracts a substring from a table column or character literal, specified in the column reference.
Trim	Deletes the leading or trailing character, or both, from a table column.
Upper	Returns a string with the same text as the string passed in, but with all letters converted to uppercase.