Concatenating Strings

SQLite, PostgreSQL and Oracle

Use the concatenation operator ||.

SELECT <value or column> || <value or column> || <value or column>  FROM <table>;

MS SQL

Use the concatenation operator +.

SELECT <value or column> + <value or column> + <value or column>  FROM <table>;

MySQL, PostgreSQL and MS SQL

Use the CONCAT() function.

SELECT CONCAT(<value or column>, <value or column>, <value or column>) FROM <table>;