The fourth and last category of new T-SQL functions is String Functions, containing two new functions. ... 9. CONCAT The CONCAT function returns a string that's the result of concatenating two or more ...