CONCAT Function Example | VantageCloud Lake - Example: CONCAT Function - Teradata VantageCloud Lake

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;