Matthew, I'm sure that others are better qualified, but, you are right about NULL is NULL. However, what that means to we humans is subject to interpretation and database config' settings, such as SET ZERO on||off. Regardless of what one chooses:
SET NULL -0- SET NULL ' ' SET NULL VOID SET NULL 1234567890 --Limit is apparently 4 characters, so this NULL would be 1234 The setting is merely a symbolic representation for we human-types. Again, how it gets treated is dependent on the decision of business users and the settings in the database. That being said, I think you need to press [SPACE] to have your NULL-values "disappear" from view. HTH, Steve in Memphis From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew Burke Sent: Friday, March 28, 2008 4:03 PM To: RBASE-L Mailing List Subject: [RBASE-L] - How do I make NULL truly NULL? I imagine there's a simple way to do this but I can't manage to figure out how. I try to use R> SET NULL '' and it does nothing, NULL keeps whatever value it previously had stored, in my case that is -0- which I believe is the default. I want NULL to be void of any and all data, both visually and logically, not represented by some text I define. Matthew Burke Pioneer Bank - IT Department Computer Systems Technician 505-627-4415 This email contains PRIVILEGED AND CONFIDENTIAL information intended only for the use of the addressee(s) named above. If you are not the intended recipient of this email, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination or copying of this email is strictly prohibited. If you have received this email in error, please notify us by replying to this email and delete this email from your records. Thank you for your cooperation.
