question re incrementing an integer field in a table.

Hope this question isn't too idiotic and makes sense.


Is there a simple way to increment the value of an integer field in a table in
sql  without reading the fields value  adding 1 and re-saving? (the field is not
a primary key or any other sort of foreign key)

regards

richard