Hi All, I wonder does Sqlite have feature such as join two string fields together. e.g: Select FirstName + LastName From Username Thank you, Ming
The '+' is a numerical addition; its result is the sum of 2 numbers; that is not what you want.
What you want is '||', the string concatenation operator.
Also, all result fields that are calculations should use AS so that their names are reasonable.
Eg: SELECT firstname || ' ' || lastname AS name FROM username
-- Darren Duncan