SQlite concat select statement
select, sqlite
Solution
Concat also the space:
SELECT NAME || ' ' || SURNAME AS USER_NAME FROM USERS
Problem
I would like to know if it is possible to concat and add a space in SQlite. This is what I mean: ``` SELECT NAME || SURNAME AS USER_NAME FROM USERS ``` But then add something to the query to let the result be displayed as: ``` Name Surname ``` and not ``` NameSurname ``` Is something like this possible in SQlite?