xxxxxxxxxx
CONCAT(column_name1, column_name2) AS column_name;
xxxxxxxxxx
WHERE CONCAT(customers.first_name, ' ', customers.last_name) LIKE '%John Smith%'
xxxxxxxxxx
USE master
GO
CREATE PROCEDURE dbo.ReturnFullName @ID int
AS
BEGIN
SELECT [First Name] + [Last Name] AS [Full Name]
FROM dbo.Persons WHERE ID= @ID
END