Learn SQL-Server Function| SQL-Server String Function | CONCAT Function

SQL-Server built-in functions

SELECT *, CONCAT(fname,' ',Mname,' ', lname) AS 'Concat Full Name'
, fname + ' ' + Mname + ' '+ lname AS 'Plus Full Name'
FROM NameData

SELECT ename, hiredate, CONCAT('Employee Name: ', ename, ' Date of Joining: ', hiredate) as LabeledDate FROM emp

#concat
#Sql-Server
#string functions
#formating
#Combine column values
#Combine different datatypes
#Null handling