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.