Re: Funny Select

Posted in 1997

Don Simon — 20 Feb 1997 15:14:57 -0500 — source: Informix-list mailing list archive (1991-1998)

Patrick Preuss (ppr@deckard.hb.north.de) wrote: : Hi, : how is it possible, that : select * from x where x.a = '' : has the same result as : select * from x where x.a = ' ' : and x.a consists of blanks? In informix '' is not the same thing as NULL, when comparing text fields, they are assumed CLIPPED, so ' ' clipped is '', which is NOT the same as the keyword NULL. I think that was the question you were asking, -- Don Simon Funk As Puck, Inc. ds5419@panix.com