Concatenate three columns into a single column named “Address”.
| SELECT Address & “, “ & PostalCode & “, “ & City AS Address FROM Customers; |
The & operator concatenates two or more strings together.
| string1 & string2 & string_n |
|
Parameter |
Description |
|
String1, string2, string_2 |
Mandatory. The strings that are to be concatenated together. |
|
Works in: |
From Access 2000 |