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

String Concatenation using SQL SERVER

by Webmaster   on Nov 24, 2010   Category: SQL Server   |  Views: 923    |  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

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