Try SET NULL ' ' - one space between quotes Your syntax does not change the NULL setting. I believe the NULL must be 1 to 4 characters.
Dennis McGrath ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Emmitt Dove Sent: Tuesday, June 22, 2010 12:33 PM To: RBASE-L Mailing List Subject: [RBASE-L] - NULL setting Folks, I'm using 7.6 to do a GATEWAY EXPORT to an XLSW. Our databases run with the NULL character set to a single dash, or (CHAR(45)). In the worksheet I need null columns to be completely empty. Here's what I've tried: SET NULL '' -- two quote marks, nothing between them GATEWAY EXPORT ..... SET NULL '-' The problem is that the worksheet still contains dashes where the column was null. How do I get those columns to be truly empty? Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected]
