Hi there,

I would like to find out whether theres an SQL function that combines two fields (in the same table) and processes them as one? So for example, I have two fields - cake & sweets.

I would like to combine the values contained within those fields. So my SQL function would output both values as one; 'cake_sweets'.

Is this possible - could it be done by combining the two fields and outputting them as an 'AS'?

EDIT: Could I do something like:-

SELECT shop.cake AND shop.sweets AS cake_sweets ?

Really appreciated your help as usual.

Kind Regards

james