We show the basic syntax for SQL’s concatenate function CONCAT, with examples on how to combine with other SQL functions such as SELECT, DISTINCT, and calculations. Worked example also shows how to create a temporary table.