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] -----------------------------------------------------------------------------
