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]
