Create a Function to Return the Employee's Full Name
Create a Function to Return the Employee's Full Name
Employees Table:
Query Explanation:
-
Function Definition (
ALTER FUNCTION dbo.GetFullName):-
The function combines the
first_nameandlast_namewith a space in between and trims any extra spaces from both sides usingLTRIM(RTRIM()).
-
-
SELECT Query:
-
The
SELECTquery calls thedbo.GetFullName()function to generate the full name for each employee based on thefirstNameandLastNamefields from theEmployeestable.
-
SQL Query:
-- Function to get full name by combining first and last name
ALTER FUNCTION dbo.GetFullName
(
@first_name VARCHAR(100),
@last_name VARCHAR(100)
)
RETURNS VARCHAR(201)
AS
BEGIN
-- Declare a variable to store the full name
DECLARE @full_name VARCHAR(201);
-- Combine first and last names, remove extra spaces
SET @full_name = LTRIM(RTRIM(@first_name + ' ' + @last_name));
-- Return the full name
RETURN @full_name;
END;
-- Query to get the full name of employees using the function
SELECT dbo.GetFullName(firstName, LastName) AS full_name
FROM Employees;
Output:
