Re: Query "<"...?

kistler@an.hp.com (Jim Kistler) wrote: >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. > If you are performing the query in 4GL, you need an extra backslash (\\) since the 4GL code parser will interpret strings and then pass the interpreted string to the engine. Example: select ... where field matches "\\\\<*" is interpreted to select ... where field matches "\\<*" and is now properly understood by the engine. Catalin. -- ========================================================================= Catalin Badea _/_/_/ _/_/_/ _/_/_/ _/_/_/ _/ _/ _/_/_/ _/ _/ _/ _/ _/_/ _/ Senior Technical Architect _/ _/_/ _/ _/_/_/ _/ _/_/_/ _/ _/ _/ _/ _/ _/ Tecsys Inc. _/ _/_/_/ _/_/_/ _/_/_/ _/ _/_/_/ ===== cat@tecsys.com =========== include system "disclaimer.4gh" ===== ===== Home Page at http://www.virtualmarketplace.com/it/TECSYSE =======