SQLite Forum

Proposal: Add the SUBSTRING alias to the SUBSTR function
For what it's worth Ingres (now Actian Ingres, I think) follows PostgreSQL and MySQL - both SUBSTR and SUBSTRING are supported. 
When I worked with and for Ingres we were stuck with LEFT and RIGHT so a substring got a little messy.