STRING CONCATENATION OPERATOR

            Using string concatenation operator is “+”, we can combine two or more strings.

Example: Extract full name from EMP table.

SELECT FirstName+' '+LastName AS FullName FROM EMP