Microsoft Query SQL Concatenate
 

Os: MS XP Excel: MS 2000

Im using Microsoft Query. I would like to concatenate within the query.
How is this done with the SQL in the query?

Thanks in advance.

--
Richard

Microsoft Query SQL Concatenate
 

Hi Richard

I think it depends on the driver you are using, but assuming you are
querying an SQL Server db then the following works for me:

SELECT Field1 + '_' + Field 2
FROM Table

so + is the concatenation operator here (the value between the single
quotes is a string literal being concatenated).

Hope this helps!

Richard



Richard wrote:

Os: MS XP Excel: MS 2000

I'm using Microsoft Query. I would like to concatenate within the query.
How is this done with the SQL in the query?

Thanks in advance.

--
Richard