penders - 4:26 pm on Oct 4, 2011 (gmt 0)
topr8 I appreciate your advice but I tried to insert null in place of an empty age field before I changed it to a varchar. That does not work.
It should. Assuming the field in the database is configured to allow NULL (ie. has not been created as 'NOT NULL') then you should be able to assign NULL to it. Note that this is NULL, the keyword, without surrounding quotes (which would make it a string).