SQL String Functions

SQL > SQL String Functions

In this section, we cover common string functions seen in SQL. Different RDBMS may employ different string functions, and there may also be differences in the syntax for each RDBMS even when the function call is the same. All such differences are explained in each section. Please note that we do not list all possible SQL string functions in this tutorial. Rather, the most commonly used ones are covered.

SQL String Function	Description
CAST	Converts data from one data type to another.
CONVERT	Converts data from one data type to another.
CONCATENATE	Combines the results of several columns together.
SUBSTRING	Returns a portion of a string.
INSTR	Finds the starting location of a pattern in a string.
TRIM	Removes specified prefix or suffix from a string. The most common pattern being removed is white space.
LENGTH	Returns the length of a string.
REPLACE	Updates the content of a string.
TO_DATE	Converts a string to a date.

This page was last updated on October 11, 2024.

AdBlock Detected!