Concatenating Strings

SQL: SELECT: Reporting

MySQL, PostgreSQL and MS SQL:

Use the CONCAT() function.

SQLite, PostgreSQL and Oracle:

Use the concatenation operator ||.

MS SQL:

Use the concatenation operator +.

//MySQL, PostgreSQL and MS SQL:

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

// SQLite, PostgreSQL and Oracle:

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

// MS SQL:

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