I'm new to SQLite, coming over from SQL Server. I often do string concatenation like so:
lastName + ', ' + firstName as [name] from myTable But it tries to run a math computation and returns '0.0' for each field. I've tried some other concat operators that I know of, but none work. How is this achieved in SQLite? Thanks! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
