Zero length string error in Update command

[sNuuu]

My database table allows for optional entry in some fields - causes a problem as my update command generates the unhandled error "zero length string" not allowed.<BR><BR>Can someone help?<BR><BR>KathySo, either set the fields in the database to allow zero length strings, or pass in NULLs instead. The first option is probably easier.Fields in the database do allow zero lengths. How do I pass in a NULL or EMPTY?<BR><BR>K