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.


A

On Fri, 11 Jan 2008 20:23:35 +0100, J.O. Aho wrote:
Not that the WHERE clause doesn't have to be there, or can be based on
any other selection criteria you like, like a LIKE for part numbers
(WHERE item_no LIKE '123%') or even on a non-item_no column (maybe a
manufacturer), or omitted altogether.

--
45. I will make sure I have a clear understanding of who is responsible for
what in my organization. For example, if my general screws up I will not
draw my weapon, point it at him, say "And here is the price for failure,"
then suddenly turn and kill some random underling. --Evil Overlord List