Re: LIKE/ESCAPE implementation

At 10:45 PM 8/5/2000, Thomas Lockhart wrote:<br /><blockquote cite="cite" type="cite">> > What is ILIKE? afaik
itis not in SQL9x, so is there any reason to have<br /> > > that rather than the full regular expression
case-insensitiveoperator<br /> > > ("~*") we already have?<br /> > Just that a lot of people have asked for
it,over and over again ...<br /> > see the archives ...<br /><br /> I had thought it would be trivial to do ILIKE,
butnow I'm not sure how<br /> to handle the multi-byte case. It isn't sufficient to wrap the<br /> single-byte
comparisonarguments with tolower() is it??<br /><br /> btw, do the archives have a full discussion of the correct
syntaxfor<br /> this? I recall people asking for it, but since it is a non-standard<br /> feature what implementation
exampleshould I follow? What alternatives<br /> are there? Is "check the archives" sufficient to produce a complete<br
/>design discussion? What thread??<br /></blockquote><br /> I don't know... As far as syntax would go, I would follow
theexisting LIKE operator, doing a case insensitive operation.<br /><br /><br /> - <br /> - <b><u>Thomas Swan</u></b>
                                  <br/> - Graduate Student  - Computer Science<br /> - The University of Mississippi<br
/>- <br /> - "People can be categorized into two fundamental <br /> - groups, those that divide people into two groups
<br/> - and those that don't."