Hey, It appears that LEFT and RIGHT are treated as reserved words by SQLite, so my attempts to use sqlite3_create_function() to create my own LEFT and RIGHT SQL functions have been unsuccessful (I'm using 3.8.11.1). Several databases (SQL Server, MySQL) define their own LEFT and RIGHT functions for performing sub-string functions, apparently without conflicting with LEFT JOIN/RIGHT JOIN syntax. Is that just not possible for SQLite?
SQLite does support its own quite powerful SUBSTR SQL function allowing obtaining substrings from either the left or the right, which is great, but I am trying to support SQL syntax that users of my product are already familiar with. But if it just has to be this way, I'll live. Thanks, Eric
