String Functions ​

This section describes functions that operate on character strings.

In This Section

• ASCII

• BIT_LENGTH

• BTRIM

• CHAR_LENGTH

• CHR

• CONCAT, ||

• CONCAT_WS

• DECRYPT (deprecated)

• DECRYPT_KS

• ENCODE

• ENCRYPT (deprecated)

• ENCRYPT_KS

• HASH

• HASH4

• HASH8

• HMAC

• HMAC_KS

• INITCAP

• INSTR

• LEFT

• LENGTH

• LOWER

• LPAD

• LTRIM, RTRIM

• MD5

• NYSIIS

• OCTET_LENGTH

• POSITION

• REPEAT

• REPLACE

• REVERSE

• RIGHT

• RPAD

• SPLIT_PART

• STRPOS

• SUBSTR

• SUBSTRING

• TO_ASCII

• TO_HEX

• TRANSLATE

• TRIM

• UPPER

Parent topic:SQL Functions and Operators