In SQL, the CONCAT function is used to concatenate (combine) two or more strings into a single string. The syntax for the CONCAT function is:

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

Where string1, string2, …, string_n are the strings that you want to concatenate. The function returns the concatenated string.

Here is an example using the CONCAT function:

Consider a customers table with the following data:


The following query returns the full name of each customer by concatenating the first_name and last_name columns:

SELECT customer_id,
       CONCAT(first_name, ' ', last_name) AS full_name
FROM customers;


1John Doe
2Jane Doe
3John Smith

In this example, the CONCAT function is used to combine the first_name and last_name columns into a single full_name column. The ' ' argument is used to add a space between the first_name and last_name values.

In conclusion, the CONCAT function in SQL is used to combine two or more strings into a single string. This function can be useful when you need to combine values from multiple columns into a single value.

Also check WHAT IS GIT ? It’s Easy If You Do It Smart

You can also visite the Git website (

Leave a Reply

Your email address will not be published. Required fields are marked *