SQLite joining two columns together in select results

Question

Is their a reason I cannot do

Select Firstname + Lastname
from Person

When using SQLite? does it not support this joining of columns... this is what i need for a view i am creating for a android project

Dupe of http://stackoverflow.com/questions/5932147/how-to-concat-columns-in-android-sqlite — Femi, Jun 10 '11 at 21:15
if I had remembered the word "Concat" i might have found that in my search! lol — Steve, Jun 12 '11 at 15:33

score 2 · Accepted Answer · answered Jun 10 '11 at 21:13

2

Select Firstname || Lastname from Person

is what you are looking for ...

answered Jun 10 '11 at 21:13

Matthieu

my hero.... is this just a SQLite thing or is it standard sql and im stuck in the mind of MSsql? – Steve Jun 11 '11 at 07:24
The only other one I know is MySQL and it is different (uses CONCAT) – Matthieu Jun 11 '11 at 18:42

1 Answers1