gmg@clark.net (Gary M. Gettier) writes:
: sft@ctc.ih.att.com (Scott_Thompson) enlightens us with:
: 
: >Assuming Gary wants to compare a literal string as his example
: >implies, use the following:
: >
: >	WHERE txt LIKE '%\[Ll\]\[Ii\]\[Gg\]\[Hh\]\[Tt\]%' ESCAPE '\'
: 
: But won't this also retrieve strings like:
: 
: lighhhht
: lxixgxhxtx
: 
: in which case that does me no good.

No the square bracket search pattern acts exactly like the UNIX regular
expression patterns.  Only one character from the set enclosed by the
square brackets is matched at the given character position in the string.

So it will match strings like:
 light
 LiGhT
 lIGht
etc.

Simon   (Simon Edwards)
===========================================================================
INGRES DBA				internet: simon@qed.qld.gov.au
Applications Unit			   voice: +61 7 237 0949
Information Technology Branch		     fax: +61 7 229 8695
Department Of Education, Queensland 
Australia				    #include 

Ingres Q & A

To William's Home Page

© William Yuan 2000

Email William