Darryl Collins
Darryl.Collins at coles.com.au
Sun Mar 29 18:27:04 CDT 2009
My understanding of NULL, in the database sense is that it is unknown. It maybe a value or it may not be, you don't know what it is. That is why if you say NULL = NULL would return false, rather than true, because you don't know what NULL is. anyone else have a different view? curious. cheers Darryl -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka Sent: Monday, 30 March 2009 10:03 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] An Interesting question So black isn't a color? ;) The absence of a value is still a value... ;) Is this going to be another great debate? Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Sunday, March 29, 2009 4:47 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] An Interesting question No :-) Null is NOT a value - it is something unknown. -- Stuart On 29 Mar 2009 at 16:37, Drew Wutka wrote: > Well on a new record, it would just be setting the default value. But > if a field is null, isn't that a value in and of itself? > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses. No warranty is made that this material is free from computer virus or any other defect or error. Any loss/damage incurred by using this material is not the sender's responsibility. The sender's entire liability will be limited to resupplying the material.