[Solved] How to join 3 columns in SQL Server Management Studio?

by


It seems that you are looking for a concat operator as below.

SELECT cust_code,
       cust_name,
       address_1 + address_2 + address_3 + address_4,
       telephone
FROM a_customer
ORDER BY cust_name ASC;

You can check the demo here

1

solved How to join 3 columns in SQL Server Management Studio?