*Original by "anonymous". Revised for formatting by "drh"* I am using the 32-bit ODBC driver from http://www.ch-werner.de/sqliteodbc/ with ADODB. ~~~~ sqlite> select 'sun' || 'flower' as flower; flower --------- sunflower ~~~~ When I use the concatenation operator `||` with an ODBC connection, it fails. How do I concatenate strings when executing an SQL statement with an ODBC connection? PS: I've tried + and & instead of `||` and I still have the failure.