SQL Server - Merge Column

Here we will learn on how can we combine two or more columns in a SQL query.

 

select UHID,ServiceName,EMR_id,is_sample_collected + ' ' + is_billing_done + ' ' + collected_sample_name as YourDesiredColumn, collected_by_User 

from HIS_Service_Order_Sample_Detail

Best Regards

Amit Vaid