SQL CONCAT function is used to concatenate two strings to form a single string. SQL CONCAT function is used to join two or more strings. It takes up to 255 input strings which are further joined by the function. For, performing join operation CONCAT requires at least 2 strings. If it is provided with only one string, it will raise an error.

SQL CONCAT Function

If any non-character string values are passed in the function, it will be implicitly converted to strings before concatenating. If any NULL is added to the function, it converts it into an empty string with VARCHAR (1).

Syntax

SELECT CONCAT (string1, string2, ... string_n)

#sql #sql concat