SQLite Forum

SELECT STATEMENT FOR OGR2OGR IN GIS
Login
Neither `LEFT(` or `RIGHT(` are valid syntax.

`LEFT(APN_D, 3)` could be `SUBSTRING(APN_D, 1, 3)`  
`RIGHT(APN_D, 3)` could be `SUBSTRING(APN_D, 7, 3)`  (or perhaps `SUBSTRING(APN_D, -3)`)

Alternatively, create the SQL functions `LEFT` and `RIGHT`.