--- Brent Baisley <[EMAIL PROTECTED]> wrote: > Quite possibly since 0 could also mean false > depending on your > comparison operator. For instance, using a generic > if statement, these > two would both evaluate to false: > if(0) > if(null) > > You should be very specific when checking for NULL. > WHERE field IS NOT NULL > or > WHERE field IS NULL > > Also, you may want to look into the NULL safe > comparison operator: > http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html > > Thank you Brent. I discovered it was the 0's. Thank you for the information. I'll be doing my reading.
Stuart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]