Search this site

Join Our Discussion

Recent site activity

Combining data

There are different approaches to combining columns into a single columns.

The following are different ways to combine Address columns into a single Address column.

CONCAT
CONCAT([Bill to Addr 1]," ",[Bill to City]," ",[Bill to State]," ",[Bill to Zip])

CONCAT_WS
CONCAT_WS(" ", [Bill to Addr 1], [Bill to City], [Bill to State], [Bill to Zip])

+
[Bill to Addr 1]+" "+[Bill to City]+" "+[Bill to State]+" "+[Bill to Zip]

Note: Quotes are added to provide space between entries.

Sign in  |  Recent Site Activity  |  Terms  |  Report Abuse  |  Print page  |  Powered by Google Sites