SQL SUBSTRING

Send request to get interview tips in PDF format Personal Interview - Answers to frequently asked questions Tips to earn promotions and perks You can also get your answers published How to write a good CV? How to write a good Cover Letter? Tips to become boss's favorite CareerRide is hiring

SQL SUBSTRING - Introduction and syntax

---

<<Previous  Next>>

SQL - Dec 03, 2008 at 18:00 PM by Rajmeet Ghai

Explain the SQL SUBSTRING statement. Write SQL syntax for the SQL SUBSTRING statement along with an example.

SQL SUBSTRING: The Substring function in SQL is used to capture a portion of the stored data

Syntax:
SUBSTR(str,pos,len): Starting with the th character in string and select the next characters.

Example:
SELECT SUBSTR(company_name, 3) FROM Company WHERE company_name = ‘tata’;

<<Previous  Next>>