Just put a default in for usernameold and it will be fine. The problem
arises when you do this with a field that is NOT NULL. If a field does
not allow NULL, then you must explicitly define one, or the insert
must include it.
-- Dale E. Reed Jr. (firstname.lastname@example.org)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com