Binary

Function Name Description
ASCII Returns the ASCII code for the first character of a string. If the string is empty, 0 is returned.
BIT_LENGTH Gets length of bits of the input expression
FROM_HEX Returns a binary value for the given hexadecimal string
ILIKE Compares two strings and returns true if they match.
INITCAP Returns the input string with the first letter of each word in uppercase and the subsequent letters in the word are in lowercase).
LOWER Returns the input expression with all the characters converted to lowercase.
LPAD Left pads a string with spaces or specified characters to reach the number of chracters specified as a parameter.
OCTET_LENGTH Returns the length of the string in bytes.
REPEAT Builds a string by repeating the input for the specified number of times
REVERSE Reverses the order of characters in a string.
RPAD Right pads a string with spaces or specified characters to reach the number of chracters specified as a parameter.
STRPOS Searches for the first occurence of the substring in the given expression and returns the position of where the substring begins. Searching binary values is also supported.
TO_HEX Returns a hexadecimal string for the given binary value.
UPPER Returns the input expression with all the characters converted to uppercase.