Join data from 2 table fields

[cswales]

I am trying to join data from 2 fields,eg,

Field1: ABC
Field2: 123

To create Field3: ABC123

Does anyone know how I can perform this.

Thanks for your help in advance.

[laserlight]

It depends on your RDMS, but probably try CONCAT() or ||

[cswales]

Hi
Sorry, could you give me a sample of this.
Thanks