If you are going to google the terms like ‘T-SQL concatenate’ to view the syntax of assumed concatenate or concate built-in function, then there is no need to do it. T-SQL allows you to concatenate two or more strings by just using + sign among strings.
To experience, use following code line in SSMS
print 'string1 '+'concatenated to '+'string2'
It would provide following result