Home » SQL Basics » In Built Functions » Using SUBSTRING Function

Using SUBSTRING Function

Using SUBSTRING Function

Syntax: Select SUBSTRING ( value_expression or column_name , start_expression , length_expression ) from Table_Name

Example: SELECT Substring(store_name,2,4)
FROM Store_Sales
WHERE store_name = ‘San Diego’;

In the above example the record for Store name San Diego will be displayed which is Substring of the Store_name as ‘as D’

Leave a Reply

Your email address will not be published. Required fields are marked *