Re: [sqlite] ltrime() and rtrim() not understood with ODBC?

Ahh, that's it. On the ODBC driver information page I see "So far it has been tested with SQLite 2.8.17 and SQLite 3.3.13" Darn! Thanks Joe! On 8/3/07, Joe Wilson <[EMAIL PROTECTED]> wrote: > rtrim was introduced on 17-Mar-07, and was in the sqlite 3.3.14 release. > >

Re: [sqlite] ltrime() and rtrim() not understood with ODBC?

rtrim was introduced on 17-Mar-07, and was in the sqlite 3.3.14 release. http://www.sqlite.org/cvstrac/chngview?cn=3698 What sqlite version is your ODBC driver? select sqlite_version(); --- Mitchell Vincent <[EMAIL PROTECTED]> wrote: > If I use sqlite3.exe to execute the query "Select >

[sqlite] ltrime() and rtrim() not understood with ODBC?

If I use sqlite3.exe to execute the query "Select customer_id,customer_number FROM customers where customer_number != rtrim(customer_number);" it works great but as soon as I run that query through using the SQLite ODBC driver (using the latest available) I get "no such function: rtrim (1)" I