Re: LIKE/ESCAPE implementation

At 01:23 AM 8/5/2000, Thomas Lockhart wrote:<br /><blockquote cite="cite" type="cite">It finally dawned on my how to
easilyimplement the LIKE/ESCAPE clause.<br /> Currently, LIKE is transformed to the "~~" operator in the parser. For<br
/>LIKE/ESCAPE, we should instead transform it to a three-parameter<br /> function call. The rest of the implementation
islikely to be trivial<br /> (as is this parsing solution).<br /></blockquote><br /> While your at it... :)   <br /><br
/>Would their be anything like an ILIKE for a case insensitive like search?   Or maybe insensitive over
text/char/varchardatatypes?<br /><br /> Just a thought...<br /><br /> Thomas<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
intotwo groups <br /> - and those that don't."