The start argument is an integer indicating the numeric position of the character in the string where the substring begins. Its syntax isįor the expression argument, you write a string literal or specify a column from which you want to extract the substring. SUBSTRING() is a text function that allows you to extract characters from a string. Some examples may feel complicated if you’re not familiar with the text functions, so make sure you have the Standard SQL Functions cheat sheet or an overview of SQL text functions by your side. In this article, we have five real-life business examples that cover the main uses of this function. One of the common text functions the course covers is SUBSTRING().

It contains 211 exercises and teaches you how to use common text, numeric, and date-and-time functions in SQL. The functions that let you do so are called text functions.įor anyone who wants to practice SQL functions, I recommend our interactive Standard SQL Functions course. Not only do you have to extract it, but often you also have to manipulate it.

But text is data, too! It’s very common to find text data in databases. When you think of working with data in SQL, your first thought is probably a database full of numbers and your SQL code doing very fancy calculations. Working with text data in SQL? We explain how to get values from any point in a string.

Substring in razorsql