How to use substring in SQL?

Question

Can anyone explain substring with example in SQL?

Answer 1

Substring () function is used to slice some characters from a string. The following is the syntax for the substring() function:

SUBSTRING( string, start_position, length)

If you want to find the first 10 characters of customer names, then following is the query for that:

SELECT SUBSTRING (Customer_name, 1, 10)

FROM Customers

If you are a beginner and want to learn SQL, then check out this SQL training course by Intellipaat.