Re: Funny Select

Posted in 1997

Douglas Wilson — Thu, 20 Feb 1997 19:15:51 -0800 — source: Informix-list mailing list archive (1991-1998)

If a is a char (not a varchar) then Informix stores a non-null 'blank' value as all spaces. Both of your queries are looking for non-null 'blanks' so they are the same. Douglas Wilson Patrick Preuss 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?