You can use CONCAT() Function

Ex:

SELECT CONCAT('SQL', ' is', ' fun!');