SQL - Structured Query Language

SELECT - Combination of Column(s)

SQL Server allows you to combine collection of column(s) by using + operator. This operator is used to concatenate two or many String data type column(s). An example, the following query is used to displays concatenate column(s) records from PRODUCT Table.

-- Example 21 --


SELECT Prod_Code + ' ' + Prod_Name AS 'Product Info' FROM Product

Query Output Screen

* * * * *

Email Your Comment To AUTHOR