Combine multiple fields into a field

[gpling]

I am trying to combine multiple fields into a field.
The table that I have at present consist of a product code, quantity and its unit.
I want to combine all 3 fields into one field.

E.g
Product Code: AB12
Quantity: 1000
Unit: KG
The combined Field should look like this: AB121000KG

Does anyone know how to implement that?
Thanks in advanced.

 

[cmmrfrds]

You can concatenate in a select statement if that is what you mean

Select (Product Code + Quantity + Unit) as newfield
From table