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.  :-)


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

Reply via email to