code:
UPDATE Tablename SET Field1='value1' WHERE Field2='value2'
See also http://www.sqlcourse.com/ for a short SQL tutorial or www.highcroft.com/highcroft/sql_intro.pdf for a very comprehensive one (I'm using it myself)
_________________________
There are two types of vessels, submarines and targets.
