CONCAT("String1", "String2") //or CONCATENATE("String1", "String2", "String3") //CONCATENATE allows more than 2 strings.