Re: Query "<"...?

: kistler@an.hp.com (Jim Kistler) writes: : Using: Informix-SQL 4.13.UD1 : Informix-ONLINE 5.03.UC5 : : Is there a way to query for "<" in a field...? : : I have tried "\\<" without success.....is there another "escape" character? : : The field I'm looking at is one of three possibilities: : : null : "<=" : " =" : : and I'd like to get counts of the "<="s vs the " ="s. Yea, this was : probably a poor choice of symbols but it does accurately describe the : input data relations that our folks find conveniently easy to remember. Have you tried =<= This may help. It does in a 4GL construct. = first in a field in query mode is supposed to tell the generator to use = instead of matches or use is null if you type nothing after the =sign (which you probably allready use to find your first alternative with null in the field). You should find your third alternative by either simply typing a space and = or = = (equal space equal). Nils.Myklebust@ccmail.telemax.no NM-data, Aasesvei 71, 1300 Sandvika, Norway My opinions are those of my company