For example, if you have two columns called first_name and last_name in a table called customers, you can use CONCAT to create a new column called full_name that combines them with a space in between.

Use the xref:System.Linq.Queryable.Concat%2A operator to concatenate two sequences. The xref:System.Linq.Queryable.Concat%2A operator is defined for ordered multisets where the orders of the receiver ...