I. Features Introduced in Ingres 2.6 : User-Visible Language Enhancements : SUBSTRING Function
 
Share this page                  
SUBSTRING Function
The ANSI compliant SUBSTRING function has been added to the SQL syntax. SUBSTRING returns part of a string starting at the specified position. The SUBSTRING function is often easier to use than combinations of LEFT and SHIFT functions that Ingres traditionally supported. The syntax is:
substring(string-expr from start-column [for length])
For details, see the SQL Reference Guide.