SQL string function SUBSTRING()

SQL string function SUBSTRING()

Syntax:

SUBSTRING(column_name, Start, Length).

Description:
Find the SUBSTRING from column data

Parameters:
Column_name – specifies the column to be manipulated
Start – Offset on the column
Length – Number of characters to be extracted

Example:

SELECT SUBSTRING(name,3,5) FROM product;

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.