<div>
SELECT (ColumnA +','+ ColumnB) AS ColumnZ<br />
FROM Table;
</div>


SELECT (ColumnA +','+ ColumnB) AS ColumnZ
FROM Table;

<div>
To be clear: There is no CONC function in Access. This is something you've picked up from somewhere else.
</div>


To be clear: There is no CONC function in Access. This is something you've picked up from somewhere else.

<div>
<div class="content wysiwyg-content">
We are using the MS access CONC function in order to merge rows for services quotes, so that if multiple values are present between rows for a single quote we merge them and separate the values by commas.<br />
<br />
We need to run below query on Sql server database but the CONC built-in function is not available in SQL server. &nbsp;Please suggest which Sql function we can use in place of CONC in Sql server.<br />
<br />
<u>Query:</u><br />
SELECT [SVC].[ID1], <br />
CONC(&quot;Market&quot;,&quot;ID1&quot;,[ID1],<wbr />&quot;SVC&quot;) AS Market, <br />
CONC(&quot;Location&quot;,&quot;ID1&quot;,[ID1<wbr />],&quot;SVC&quot;) AS Location, <br />
CONC(&quot;Requestor&quot;,&quot;ID1&quot;,[ID<wbr />1],&quot;SVC&quot;) AS Requestor, <br />
CONC(&quot;HW Quote Generated By&quot;,&quot;ID1&quot;,[ID1],&quot;SVC&quot;) AS [HW Quote Generated By],<br />
CONC(&quot;Cabinet&quot;,&quot;ID1&quot;,[ID1]<wbr />,&quot;SVC&quot;) AS Cabinet<br />
From Temp_Name
</div>
</div>


We are using the MS access CONC function in order to merge rows for services quotes, so that if multiple values are present between rows for a single quote we merge them and separate the values by commas.

We need to run below query on Sql server database but the CONC built-in function is not available in SQL server.  Please suggest which Sql function we can use in place of CONC in Sql server.

Query:
SELECT [SVC].[ID1], 
CONC("Market","ID1",[ID1],"SVC") AS Market, 
CONC("Location","ID1",[ID1],"SVC") AS Location, 
CONC("Requestor","ID1",[ID1],"SVC") AS Requestor, 
CONC("HW Quote Generated By","ID1",[ID1],"SVC") AS [HW Quote Generated By],
CONC("Cabinet","ID1",[ID1],"SVC") AS Cabinet
From Temp_Name

Alternative function for CONC in Sql server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.