CONCAT vs. TEXTJOIN: Which function should I choose to concatenate data?
both concat and textjoin help you to concatenate data in different cells. let's learn how to use tipsmake.com.com, the difference between them to see which function you shouldCONCAT function in SQL Server
learn how to use the concat () function in sql server to join two or more strings into a string.