String Functions and Operators The week number is different from what the  WEEK()  function would return ( 0 ) for optional arguments  0 or  1 , as  WEEK()  then returns the week in the context of the given year. -> 198652 12.8 String Functions and Operators Table 12.12 String Functions and Operators Name Description ASCII() Return numeric value of left-most character BIN() Return a string containing binary representation of a number BIT_LENGTH() Return length of argument in bits CHAR() Return the character for each integer passed CHAR_LENGTH() Return number of characters in argument CHARACTER_LENGTH() Synonym for CHAR_LENGTH() CONCAT() Return concatenated string CONCAT_WS() Return concatenate with separator ELT() Return string at index number EXPORT_SET() Return a string such that for every bit set in the value bits, you get an on string and for every unset bit, you get an off string FIELD() Index (position) of first argument in subsequent arguments FIND_IN_SET() Index (position) of first argument within second argument FORMAT() Return a number formatted to specified number of decimal places FROM_BASE64() Decode base64 encoded string and return result HEX() Hexadecimal representation of decimal or string value INSERT() Insert substring at specified position up to specified number of characters INSTR() Return the index of the first occurrence of substring LCASE() Synonym for LOWER() LEFT() Return the leftmost number of characters as specified LENGTH() Return the length of a string in bytes LIKE Simple pattern matching LOAD_FILE() Load the named file LOCATE() Return the position of the first occurrence of substring LOWER() Return the argument in lowercase 2171