SQLite problem selecting two columns as one

Basic table with empname and empdpt.
In a Sql Server table, I can do Select empname + ' ' + empdpt as expr1 no problem.
Can't do the same using Sqlite!!
When I try to combine two columns [with data], I get back a 0.
I've tried in sqliteman and sqliteadmin as well as Server Explorer in VS.

sqlite3

2009-06-16 19:00
by NoName

Try using the following:

SELECT ("test" || " " || "test2") AS expr1 ;

Update

If these are columns you can do something similar: SELECT (column1 || " " || column2) AS expr1 FROM your_table;

2009-06-16 19:05
by merkuro

Select empname || " " || empdpt as expr1 works...thanks...Any idea why the basic a + b doesn't work in Sqlite - NoName 2009-06-16 19:08

Nope, sorry. Don't know any reason and haven't found any answer for this on http://www.mail-archive.com/sqlite-users@sqlite.org/. However someone said that it is the same as in Oracle and PostgreSQL. Here are a couple other functions that might be interesting for you (Sqlite3): http://www.sqlite.org/lang_aggfunc.htm - merkuro 2009-06-16 19:17

Select empname || " " || empdpt as expr1

The sqllite concat is the same as PostGreSQL ( || ) and not MYSQL or MSSQL 'CONCAT'

2009-06-16 19:06
by Pierre Gayvallet

got it...not used to | - NoName 2009-06-16 19:13

for those who are trying to use the (working) solution of @merkuru

SELECT (column1 || " " || column2) AS expr1 FROM your_table;

in eclipse or another editor:

you have to cancel the " with \

something like:

SELECT (column1 || \" \" || column2) AS expr1 FROM your_table;

that's works perfect

2014-03-23 08:39
by dvrm