CONCAT Function Example | Teradata Vantage - Example - Analytics Database - Teradata Vantage

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;