>> Second, if I'm correct, the default value only applies to new records
should no value be pleased in that field. <<

No, you can use it in your UPDATE statement as I have shown in my post.

>> Also, what differentiates one record from the whole table? <<

You have to use a proper WHERE clause to identify the rows which are
affected by the UDPATE statement.

--
-- Anith
( Please reply to newsgroups only )