Home > Code > SQL Server > String Concatenation using SQL SERVER

String Concatenation using SQL SERVER

by Webmaster   on Nov 24, 2010   Category: SQL Server   |  Views: 1347    |  Points: 25   |  Starter 


In SQL server we can use + operator to join string or table column values.
Below is the sample code for join two string
SELECT 'Dotnet' + ' ' + 'Gallery' AS Name

Below is the sample code to join with table column values

SELECT FName + ' ' + LName AS Name FROM tblMstContact


-Webmaster


Post Code  |  Code Snippet Home

Recent Posts

User Responses


No response found, be the first to review this code snippet.

Submit feedback about this code snippet

Please sign in to post feedback

Latest Posts