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 |
* * * * *