Is there an SQL function that can combine two fields into one?
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.