RE: Unloading Null Values, 0 length strings and spaces...

You can use NVL function to solve this particular problem. But then you will have problem with loading data. If value you're trying to catch is not null then you can use CASE expressions. HTH Vardan -- vaar@geocities.com -----Original Message----- From: Michael Brizendine [SMTP:michaelb@pegsinc.com] Sent: Thursday, July 08, 1999 9:30 AM To: informix-list@iiug.org Subject: Unloading Null Values, 0 length strings and spaces... All, I am wondering if anyone knows a way to force the unload statement into unloading the word null or something like that so that I can differentiate a null value from a space or a 0 length string. With the unload in its current state all the above values look like || when unloaded... This is a maint. nightmare for me since we have some tables with bad data. I'm on Informix 7.31 and sun 2.6. Thanks much, Michael Brizendine michaelb@pegsinc.com