What is the use of concat function?

Answer 1

hi,
concat or concatenate is a function used in SQL to combine several
expressions together
////////////////////////////////////////
example:-
///////////////////////////////////////
SELECT CONCAT("SQL ", "Tutorial ", "is ", "fun!") AS ConcatenatedString;

Answer 2

example:-
SELECT CONCAT(Address, " ", PostalCode, " ", City) AS Address
FROM Customers;