How to SELECT fields values from a table as cocatenated string

  • Thread starter Thread starter Guest
  • Start date Start date
Hi Shalash,

Create a query and go to Sql view and type:

SELECT Field1 & Field2 AS myStr FROM Table1

the symbol & is used for this purpose
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cocatenate not showing leading zeros MS Excel 2003 6
Can vlookup work using formula values? 5
How to Populate Data from a table to another 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
extract 3 numbers from a string 0
How can I extract each Max key value ? 2
Select Portion of a Text String 4
VB Script file save as with date 3

Back
Top