Re: PLEASE PLEASE PLEASE Help Me!!!

Posted in 1994

"Neil S. Briscoe" — Wed, 23 Nov 1994 18:31:46 +0000 — source: Informix-list mailing list archive (1991-1998)

You simply can't do what you want. In databases, NULL means unknown. As soon as you place any characters into a character variable, it now has a known value. Is the reason for trying to put a "NULL" after the data so that you don't get a load of spaces in reports? Then look at the CLIPPED function, which will eradicate trailing spaces in variables. Regards Neil