Tuesday, February 2, 2010

SQL SUBSTRING

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’;

0 Comments: