NULL is a display setting, and as such cannot be set to NULL The best you can do is SET NULL ' ' Which is a single space.
It does not affect data in a table that is null, it will still be null. What exactly are you trying to do? Dennis McGrath ________________________________ 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.
