How to concatenate two different values from two different columns with comma " , " using TSQL?

Question

I would like to know how to concatenate two different values from two different columns from a SQL table using TSQL ?

As you can see, I would like to concatenate those two different columns X e Y, resulting in the follow column table:

Which query should be used here ?

Answer 1

You can use concat as

SELECT 
    Source, QtyPrevious, QtyToday, ProductPrevious, ProductToday, 
    AvaDatePr, AvaDateToday, Clusters, CONCAT(X, '', Y) as Z 
from your_table_name;