The CONCAT
function joins two or more string values together.
CONCAT
converts all arguments to string types before concatenation.
CONCAT
converts any NULL argument to an empty string.
This example joins three string values into a single string.
SELECT CONCAT('Lars',' ','Anderson') AS Name
Name |
---|
Lars Anderson |
CONCAT
takes two or more arguments.
The return value is either VARCHAR
or NVARCHAR
depending on the input types.
Syntax for the CONCAT function.
CONCAT (value1, value2, ...., valueN)
values
-- required. Two or more parameters that can be converted to string.
CUSTOMER |
---|
Id |
FirstName |
LastName |
City |
Country |
Phone |
SELECT CONCAT(FirstName, ' ', LastName) AS Name,
City, Country
FROM Customer
Name | City | Country |
---|---|---|
Maria Anders | Berlin | Germany |
Ana Trujillo | México D.F. | Mexico |
Antonio Moreno | México D.F. | Mexico |
Thomas Hardy | London | UK |
Christina Berglund | Luleå | Sweden |
SELECT OrderNumber, ProductName,
CONCAT(I.Quantity, ' x $', NULL,
I.UnitPrice, ' = $',
I.UnitPrice * I.Quantity) AS Calculation
FROM OrderItem I
JOIN [Order] O ON O.Id = I.OrderId
JOIN Customer C ON C.Id = O.CustomerId
JOIN Product P ON P.Id = I.ProductId
WHERE OrderNumber = '542382'
OrderNumber | ProductName | Calculation |
---|---|---|
542382 | Sir Rodney's Marmalade | 40 x $64.80 = $2592.00 |
542382 | Geitost | 25 x $2.00 = $50.00 |
542382 | Camembert Pierrot | 40 x $27.20 = $1088.00 |