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
On this page of the site you can watch the video online Learn SQL-Server Function| SQL-Server String Function | CONCAT Function with a duration of hours minute second in good quality, which was uploaded by the user Query Quest 09 March 2025, share the link with friends and acquaintances, this video has already been watched 89 times on youtube and it was liked by 0 viewers. Enjoy your viewing!