It is used to concatenate two or more strings.

BY Best Interview Question ON 29 Jun 2020

Example

SELECT CONCAT('BestInterview', ' ', 'Question') AS 'Name';