SQLite String Functions

The SQLite char() function accepts a series of Unicode code point values ​​as parameters and returns a string consisting of the characters corresponding to these parameters in the order of the parameters.

Use SQLite format() to format strings and numbers in SQLite 3.38.0 and later. It is the renamed printf() SQL function; older versions use printf().

The SQLite glob() function checks if a given string matches a given pattern.

The SQLite hex() function treats the parameter as a BLOB and returns a string representing the hexadecimal uppercase form of this BLOB.

The SQLite instr() function finds the first occurrence of a given string within a given string, and returns a number (1-based) representing the position of the first occurrence if found, otherwise 0.

The SQLite length() function returns the number of characters in a given string, or return the number of bytes in a given blob value.

The SQLite like() function checks if a given string matches a given pattern.

The SQLite lower() function converts the given string to lowercase and returns it.

The SQLite ltrim() function removes the longest string containing all the characters specified by the parameter (whitespace by default) from the start a string.

Use SQLite printf() to format strings and numbers with %s, %d, %f, and SQLite-specific quoting specifiers. It remains an alias for format().

The SQLite quote() function takes arguments and return them as SQL literals.

The SQLite randomblob() function returns a blob consisting of a given number of pseudorandom bytes.

SQLite replace(X,Y,Z) replaces every occurrence of Y in X with Z. Learn how BINARY matching, empty search strings, and replacement-value conversion work.

The SQLite rtrim() function removes the longest string containing all the characters specified by the parameter (whitespace by default) from the end of a string.

The SQLite substr() function extracts and returns a substring from a specified string according to the specified starting position and length.

The SQLite substring() function extracts and returns a substring from a specified string according to the specified starting position and length.

The SQLite trim() function removes the longest string containing all the characters specified by the parameter (whitespace by default) from the start and end of a string.

The SQLite unicode() function returns the Unicode code point of the first character of the specified string.

The SQLite upper() function converts the given string to uppercase and returns it.

The SQLite zeroblob() function returns a blob containing the given number of bytes of 0x00.