Example: Concatenating Last Name with First Name - Teradata Vantage

Change the SELECT and the separator to get last and first names:

SELECT lname||', '||fname 
FROM names 
ORDER BY lname;

The result is:

((lname||', ')||fname) 
----------------------
Brown, Alan 
Kanieski, Carol 
Ryan, Loretta 
Villegas, Arnando