Somebody recently asked me this question and I thought that a some others out there might not know this little trick; SQL gurus please ignore:

When editing data in a table view from within SQL Enterprise Manager (2000 or 2005) you can NULL the field by hitting Ctrl+0 when the cell has focus.  Deleting the data completely does not do it.  Typing in "NULL" does not do it either.