Jason Salas wrote: > Never mind folks...I got it! > > Double-pipes does the trick! "||" > > lastName || ', ' || firstName as [name] from myTable > > > Awesome. Admittedly confusing at first glance, but awesome. :-)
This is plain vanilla, standard SQL according to the standard. You will find that Sqlite sticks to the standard quite well so if you write ANSI SQL it is not only understood by Sqlite but be portable. > > > Jason Salas wrote: >> 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 >> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users