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? Thanks! -- - Mitchell Vincent ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------