On this page

    Binary

    Function NameDescription
    ASCIIReturns the ASCII code for the first character of a string. If the string is empty, 0 is returned.
    BIT_LENGTHGets length of bits of the input expression
    FROM_HEXReturns a binary value for the given hexadecimal string
    INITCAPReturns the input string with the first letter of each word in uppercase and the subsequent letters in the word are in lowercase).
    LOWERReturns the input expression with all the characters converted to lowercase.
    LPADLeft pads a string with spaces or specified characters to reach the number of chracters specified as a parameter.
    OCTET_LENGTHReturns the length of the string in bytes.
    REPEATBuilds a string by repeating the input for the specified number of times
    REVERSEReverses the order of characters in a string.
    RPADRight pads a string with spaces or specified characters to reach the number of chracters specified as a parameter.
    STRPOSSearches 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_HEXReturns a hexadecimal string for the given binary value.
    UPPERReturns the input expression with all the characters converted to uppercase.