CONCAT Function Example | Teradata Vantage - 17.10 - Example - Advanced SQL Engine - Teradata Database

The result of this statement is Hello World!

SELECT CONCAT('Hello', 'World', '!')

This statement concats the first name with the last name.

SELECT CONCAT(fname, lname) FROM Names;