# Overview

> For the complete documentation index, see [llms.txt](https://docs.redpanda.com/llms.txt). Component-specific: [cloud-data-platform-full.txt](https://docs.redpanda.com/cloud-data-platform-full.txt)

---
title: Overview
latest-operator-version: v26.1.4
latest-console-tag: v3.7.3
latest-connect-version: 4.93.0
latest-redpanda-tag: v26.1.9
docname: sql/sql-functions/string-functions/index
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/sql-functions/string-functions/index.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/sql-functions/string-functions/index.adoc
description: String functions analyze and manipulate string values.
page-git-created-date: "2026-05-26"
page-git-modified-date: "2026-05-26"
---

<!-- Source: https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-functions/string-functions.md -->

Use string functions to analyze and manipulate string values. Redpanda SQL supports these string related functions and operators:

## [](#string-functions)String functions

| Function | Description |
| --- | --- |
| length() | Returns the number of characters in a string |
| lower() | Makes string lowercase |
| upper() | Makes string upper case |
| starts_with() | Checks if a string starts with a specified substring |
| ends_with() | Checks if a string ends with a specified substring |
| concat() | Adds two or more strings together |
| SUBSTRING | Extracts a substring from a string. SUBSTR is an alias. |
| strpos() | Finds the position at which the substring starts within the string |
| regexp_match() | Matches a POSIX regular expression pattern to a string |
| regexp_replace() | Substitutes new text for substrings that match POSIX regular expression patterns |
| replace() | Finds and replace occurrences of a substring in a string |
| POSITION | Returns the position of the first occurrence of a substring in a string |

## [](#string-operators)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. |