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. > > 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 > > 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 thought at first that maybe sqlite3.exe just had extra extension > > functions compiled in but http://www.sqlite.org/lang_expr.html says > > ltrim and rtrim are "core". > > > > Is there something I have to do to get ltrim/rtrim to work over ODBC? > > > > > ____________________________________________________________________________________ > Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for > today's economy) at Yahoo! Games. > http://get.games.yahoo.com/proddesc?gamekey=monopolyherenow > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > -- - Mitchell Vincent - K Software - Innovative Software Solutions - Visit our website and check out our great software! - http://www.ksoftware.net ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------