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
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.

Was this page helpful?

Glad to hear it! Thank you for your feedback. Sorry to hear that. Thank you for your feedback.