Hi

I have database table with two columns, I want to update some values by adding a text at the beginning and at the end of these values!?

For example:
Table name: food
Column 1 name: food id
Column 2 name: plant

Original values in the table before adding text update:

[food id] [plant]
--------------------------
[1] [APPLE FR]
[2] [BANANA FR]
[3] [TOMATO FR/VEG]


Values in the table after adding text update:

[food id] [plant]
--------------------------
[1] [GRANNY SMITH APPLE FRUIT]
[2] [BLUEFIELD BANANA FRUIT]
[3] [CHERRY TOMATO FRUIT/VEGETABLE]

Note: there are spaces between the values in the column

Anybody help me please with update scripts
Regards…