Wednesday, 30 March 2011

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

No comments:

Post a Comment