Which function in SQL is used to merge two or more strings?

Programming Language
#1

The CONCAT function in SQL is a String function, which is used to merge two or more strings. The Concat service converts the Null values to an Empty string when we display the result. This function is used to concatenate two strings to make a single string. The operator is used to link character strings and column string.

We can use a literal in CONCAT Function. A literal is a number, character, or date that includes the SELECT statement.

Syntax:

SELECT CONCAT (String 1, String 2, String3.., String N) FROM [Source]

Example:

SQL> SELECT CONCAT('FIRST ', 'SECOND');
+----------------------------+
| CONCAT('FIRST ', 'SECOND') |
+----------------------------+
| FIRST SECOND               |
+----------------------------+
1 row in set (0.00 sec)