> ## Documentation Index
> Fetch the complete documentation index at: https://docs.oxla.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Overview

String functions are used to analyze and manipulate string values. Oxla supports the following string related functions and operators:

### String Functions

| **Function**                                                                            | **Description**                                                                  |
| --------------------------------------------------------------------------------------- | -------------------------------------------------------------------------------- |
| [LENGTH()](/sql-reference/sql-functions/string-functions/length)                        | Returns the number of characters in a string                                     |
| [LOWER()](/sql-reference/sql-functions/string-functions/lower)                          | Makes string lowercase                                                           |
| [UPPER()](/sql-reference/sql-functions/string-functions/upper)                          | Makes string upper case                                                          |
| [STARTS\_WITH()](/sql-reference/sql-functions/string-functions/starts-with)             | Checks if a string starts with a specified substring                             |
| [ENDS\_WITH()](/sql-reference/sql-functions/string-functions/ends-with)                 | Checks if a string ends with a specified substring                               |
| [CONCAT()](/sql-reference/sql-functions/string-functions/concat)                        | Adds two or more strings together                                                |
| [SUBSTR()](/sql-reference/sql-functions/string-functions/substr)                        | Extracts a substring from a string                                               |
| [STRPOS()](/sql-reference/sql-functions/string-functions/strpos)                        | Finds the position at which the substring starts within the string               |
| [REGEXP\_MATCH()](/sql-reference/sql-functions/string-functions/regex/regexp-match)     | Matches a POSIX regular expression pattern to a string                           |
| [REGEXP\_REPLACE()](/sql-reference/sql-functions/string-functions/regex/regexp-replace) | Substitutes new text for substrings that match POSIX regular expression patterns |
| [REPLACE()](/sql-reference/sql-functions/string-functions/replace)                      | Finds and replace occurences of a substring in a string                          |
| [POSITION()](/sql-reference/sql-functions/string-functions/position)                    | Returns the position of the first occurrence of a substring in a string          |

### String Operators

| **Operator**               | **Description**                                                                                                    |
| -------------------------- | ------------------------------------------------------------------------------------------------------------------ |
| text \~ text -> boolean    | Returns `true` if the first argument matches the pattern of the second argument in case sensitive match            |
| text \~\* text -> boolean  | Returns `true` if the first argument matches the pattern of the second argument in a case-insensitive match        |
| text !\~ text -> boolean   | Returns `true` if the first argument does not match the pattern of the second argument in case sensitive match.    |
| text !\~\* text -> boolean | Returns `true` if the first argument does not match the pattern of the second argument in a case-insensitive match |