Sign inTry Free
  • Introduction
    • Deploy
      • Connect to Your Cluster
        • Create a Database
          • Integrate with SingleStoreDB
            • Load Data
              • Query Data
                • Manage Data
                  • Developer Resources
                    • User and Cluster Administration
                      • Reference
                        • Configuration Reference
                          • SingleStoreDB Operator Reference
                            • SingleStore Tools Reference
                              • SQL Reference
                                • SQL Command Syntax
                                • SQL Commands List
                                • SQL Functions List
                                • Comparison Operators and Functions
                                  • Database Object Case-Sensitivity
                                  • Data Types
                                    • Character Encoding
                                      • Operations that Take Either a Database or a Cluster Level Lock
                                        • User-Defined Variables
                                          • Restricted Keywords
                                            • Aggregate Functions
                                              • Cluster Management Commands
                                                • Code Generation Functions
                                                  • Conditional Functions
                                                    • Data Definition Language DDL
                                                      • Data Manipulation Language DML
                                                        • Date and Time Functions
                                                          • Distinct Count Estimation Functions
                                                            • Full-Text Search Functions
                                                              • Geospatial Functions
                                                                • Identifier Generation Functions
                                                                  • Information Functions
                                                                    • JSON Functions
                                                                      • Numeric Functions
                                                                        • Operational Commands
                                                                          • Pipelines Commands
                                                                            • Procedural SQL Reference
                                                                              • Regular Expression Functions
                                                                                • Resource Pool Commands
                                                                                  • Security Management Commands
                                                                                    • SHOW Commands
                                                                                      • String Functions
                                                                                        • AES_DECRYPT
                                                                                        • AES_ENCRYPT
                                                                                        • ASCII
                                                                                        • BIN
                                                                                        • BINARY
                                                                                        • CHAR
                                                                                        • CHARACTER_LENGTH
                                                                                        • CHARSET
                                                                                        • CONCAT
                                                                                        • CONCAT_WS
                                                                                        • CRC32
                                                                                        • FIELD
                                                                                        • FORMAT
                                                                                        • FROM_BASE64
                                                                                        • QUOTE
                                                                                        • HEX
                                                                                        • INET_ATON
                                                                                        • INET_NTOA
                                                                                        • INET6_ATON
                                                                                        • INET6_NTOA
                                                                                        • INITCAP
                                                                                        • INSTR
                                                                                        • LCASE
                                                                                        • LEFT
                                                                                        • LENGTH
                                                                                        • LOCATE
                                                                                        • LPAD
                                                                                        • LTRIM
                                                                                        • MD5
                                                                                        • REPLACE
                                                                                        • RIGHT
                                                                                        • RPAD
                                                                                        • RTRIM
                                                                                        • SHA1
                                                                                        • SHA2
                                                                                        • SPLIT
                                                                                        • STRING_BYTES
                                                                                        • SUBSTRING
                                                                                        • SUBSTRING_INDEX
                                                                                        • TO_BASE64
                                                                                        • TRIM
                                                                                        • UCASE
                                                                                        • UNHEX
                                                                                      • Time Series Functions
                                                                                        • Vector Functions
                                                                                          • Window Functions
                                                                                          • Troubleshooting Reference
                                                                                            • System Databases
                                                                                            • Information Schema Reference
                                                                                              • Data API
                                                                                              • Security
                                                                                                • Release Notes
                                                                                                  • Support
                                                                                                    • Glossary
                                                                                                    1. Self-Managed v7.5
                                                                                                    2. /
                                                                                                    3. ...
                                                                                                    4. /
                                                                                                    5. String Functions

                                                                                                    String Functions

                                                                                                    In this section

                                                                                                    • AES_DECRYPT
                                                                                                    • AES_ENCRYPT
                                                                                                    • ASCII
                                                                                                    • BIN
                                                                                                    • BINARY
                                                                                                    • CHAR
                                                                                                    • CHARACTER_LENGTH
                                                                                                    • CHARSET
                                                                                                    • CONCAT
                                                                                                    • CONCAT_WS
                                                                                                    • CRC32
                                                                                                    • FIELD
                                                                                                    • FORMAT
                                                                                                    • FROM_BASE64
                                                                                                    • QUOTE
                                                                                                    • HEX
                                                                                                    • INET_ATON
                                                                                                    • INET_NTOA
                                                                                                    • INET6_ATON
                                                                                                    • INET6_NTOA
                                                                                                    • INITCAP
                                                                                                    • INSTR
                                                                                                    • LCASE
                                                                                                    • LEFT
                                                                                                    • LENGTH
                                                                                                    • LOCATE
                                                                                                    • LPAD
                                                                                                    • LTRIM
                                                                                                    • MD5
                                                                                                    • REPLACE
                                                                                                    • RIGHT
                                                                                                    • RPAD
                                                                                                    • RTRIM
                                                                                                    • SHA1
                                                                                                    • SHA2
                                                                                                    • SPLIT
                                                                                                    • STRING_BYTES
                                                                                                    • SUBSTRING
                                                                                                    • SUBSTRING_INDEX
                                                                                                    • TO_BASE64
                                                                                                    • TRIM
                                                                                                    • UCASE
                                                                                                    • UNHEX

                                                                                                    Last modified: February 6, 2023

                                                                                                    Was this article helpful?

                                                                                                    System Status
                                                                                                    AES_DECRYPT

                                                                                                    Product

                                                                                                    • Product Overview
                                                                                                    • Solutions
                                                                                                    • Pricing
                                                                                                    • Support

                                                                                                    Community

                                                                                                    • Forums
                                                                                                    • Developer Hub
                                                                                                    • Events
                                                                                                    • Training

                                                                                                    Company

                                                                                                    • Contact Us
                                                                                                    • Blog
                                                                                                    • Careers
                                                                                                    • SingleStore Connect

                                                                                                    This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

                                                                                                    • © SingleStore
                                                                                                    • |

                                                                                                    • Privacy Policy
                                                                                                    • |

                                                                                                    • Terms of Service
                                                                                                    • |

                                                                                                    • Legal Terms and Conditions

                                                                                                    Was this article helpful?