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