what I'm asking is whether there's a
difference between a field with NULL in it and a field with a
zero-length ("") string in it.
Yes, there is. NULL is the absence of a value; an empty string is a valid value. NULL by definition isn't equal to anything, even to itself, while "" = "".
Bruce Feist
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
