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

A string function is a built-in function or method that performs operations on a sequence of characters (or string) in a programming language. These functions can be used to manipulate, search, and modify string data.

BOOL_OR

String Functions

LENGTH

Oxla Developer Hub

Homepage

OLTP vs OLAP

Oxla vs. Other OLAP Solutions

Our Key Features

Key Concepts & Architecture

Introduction

Getting Started

SQL TABLE

CREATE TABLE statement

CREATE INDEX statement

SELECT statement

DROP statement

SHOW TABLES statement

DESCRIBE statement

COPY FROM statement

SQL Queries

FROM

WHERE

GROUP BY

HAVING

ORDER BY

LIMIT

OFFSET

SQL Clauses

Data Type Operators

Boolean Type

Date Type

Timestamp Type

Interval Type

String Type

Numeric Type

JSON Type

SQL Data Types

Numeric Functions

Aggregation Functions

Timestamp Functions

Boolean Function

JSON Functions

Other Functions

SQL Functions

Schema

SQL Reference

Error Handling

Differences Between Oxla vs. PostgreSQL

Functions	Description
LENGTH()	Returns the number of characters in a string.
LOWER()	Makes string lowercase.
UPPER()	Makes string upper case.
STARTS_WITH()	It returns true if the first argument starts with the second argument.
ENDS_WITH()	It returns true if the first argument ends with the second argument.
CONCAT()	Concatenates all inputs into a single result. Concatenates all inputs into a single result. Concatenates all inputs into a single result. Concatenates all inputs into a single result. Concatenates all inputs into a single result.
SUBSTR()	Retrieves substring.
STRPOS()	Finds the position at which the substring (defined as a second argument) starts within the string (defined as a first argument).
REGEXP_REPLACE()	Substitutes new text for substrings that match POSIX regular expression patterns.
REPLACE()	Finds and replaces a substring with a new one in a string.

Functions	Description
text ~ text -> boolean	Return true if the first argument matches the pattern of the second argument in case sensitive match.
text ~* text -> boolean Return true if first argument matches pattern of second argument in case sensitive match.	Return true if the first argument matches the pattern of the second argument in a case-insensitive match.
text !~ text -> boolean	Return true if the first argument does not match the pattern of the second argument in case sensitive match.
text !~* text -> boolean	Return true if the first argument does not match the pattern of the second argument in a case-insensitive match.