SQL CONCAT() Function

SQL CONCAT() Syntax

The below syntax is used to concatenate strings from a given input string or expression.

For SQL SERVER / MYSQL

SELECT CONCAT(string1, string2, ..., stringN);

For ORACLE

SELECT CONCAT(string1, string2);

Note: The Oracle CONCAT() function will support only 2 string at once.

The below syntax is how to concatenate multiple strings in oracle:

SELECT CONCAT(CONCAT(string1, string2), string3);

For MS ACCESS

SELECT string1 & string2;

Note: The CONCAT() function will not support by ms access. It uses "&" operator to concatenate a strings.

The below syntax is used to concatenate strings from a in a specific column value.

For SQL SERVER / MY SQL

SELECT CONCAT(column_name1, column_name2) FROM table_name;

For MS ACCESS

SELECT column_name1 & column_name2 & ...column_nameN) FROM table_name;

SQL CONCAT() Example - Using Expression Or Formula

The following SQL SELECT statement concatenate three strings as a single string.

SELECT CONCAT('Sql', ' ', 'Tutorial') AS 'Concatenated Strings';

The result of above query is:

Sample Database Table - Employee

SQL CONCAT() Example

The following SQL statement concatenate the "FName" and "LName" column from the "Employee" table and produce a new column called as "EmpName" to the result set:

For SQL SERVER / MySql

SELECT ID, CONCAT(FName, ' ', LName) As 'Emp Name', 
City FROM Employee;

For MS Access

SELECT ID, FName & ' ' & LName As 'Emp Name', 
City FROM Employee;

The result of above query is: