OPTION BLANK_IF_ZERO.
It helps to read HELP GATEWAY . 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] From: [email protected] [mailto:[email protected]] On Behalf Of Emmitt Dove Sent: Tuesday, June 22, 2010 13:33 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]
