SQL Concatenate Function

SQL > SQL String Functions > Concatenate

The Concatenate function combines multiple character strings together. Each database provides its own way(s) to do this:

MySQL: CONCAT( )
Oracle: CONCAT( ), ||
SQL Server: +

Syntax

The syntax for CONCAT( ) is as follows:

CONCAT (str1, str2, str3, ...)

The above syntax concatenates str1, str2, str3, and any other strings together. Each str can be a column name, or it can be a literal character string (meaning a sequence of characters enclosed by two single quotes), or just white space.

Please note the Oracle CONCAT( ) function only allows two arguments -- only two strings can be put together at a time using this function. However, it is possible to concatenate more than two strings at a time in Oracle using '||'.

The syntax for using '||' to concatenate is as follows:

str1 || str2 || str3 ...

The syntax for using '+' to concatenate is as follows:

str1 + str2 + str3 ...

Examples

We use the following table for our examples.

Table Geography

Region_Name	Store_Name
East	Boston
East	New York
West	Los Angeles
West	San Diego

Example 1: Use CONCAT function to concatenate

MySQL/Oracle:

SELECT CONCAT(Region_Name, Store_Name) FROM Geography
WHERE Store_Name = 'Boston';

Result:

'EastBoston'

Example 2: Use '||' to concatenate

Oracle:

SELECT Region_Name || ' ' || Store_Name FROM Geography
WHERE Store_Name = 'Boston';

Result:

'East Boston'

Example 3: Use '+' to concatenate

SQL Server:

SELECT Region_Name + ' ' + Store_Name FROM Geography
WHERE Store_Name = 'Boston';

Result:

'East Boston'

Next: SQL SUBSTRING

This page was last updated on October 12, 2024.

AdBlock Detected!

Our website is made possible by displaying ads to our visitors. Please supporting us by whitelisting our website.