Prev Next
SQL CONCAT() function is used to concatenate 2 or more strings together and forms a single string. Syntax for SQL CONCAT() function is given below.
SQL Syntax for CONCAT() function:
| Syntax for CONCATE() function in SQL | SELECT CONCATE (string1, string2) FROM table_name; |
Please consider the following table with few records as given below.
Table name (for example): student
Column names in this table: Student_ID, First_name, Last_name, City and Marks
Available records: 4 rows