Auddog wrote:
> I have a table (inventory) with field (item_no) and would like to add some
> information to the end of the existing data in the item_no field. In
> example, item_no = 1234-01 would now be 1234-01(wp). I'm not quite sure
> where to even start and I've never done anything like this and I have
> several hundred items to update.

UPDATE table SET item_no=concat(item_no,'(wp)') WHERE item_no='1234-01';

--

//Aho