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.