Wow...this is great news....I will try the CLIKE function tonight. ----- Original Message ----- From: "Jeff Zucker" <[EMAIL PROTECTED]> To: "Simon Oliver" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; " Christopher J. Crane" <[EMAIL PROTECTED]> Sent: Thursday, January 10, 2002 11:51 AM Subject: Re: [Fwd: CSV SQL Statements]
> Simon Oliver wrote: > > > > Looking through the docs I notice that CLIKE is mentioned, but there is no > > explanation of the difference between the two operators - perhaps there should > > be. > > I'm working on the POD now. Here's what it will say: > > The "CLIKE" operator works exactly the same as the "LIKE" > operator, but is case insensitive. For example: > > WHERE foo LIKE 'bar%' # succeeds if foo is "barbaz" > # fails if foo is "BARBAZ" or "Barbaz" > > WHERE foo CLIKE 'bar%' # succeeds for "barbaz", "Barbaz", and > "BARBAZ" > > Sound ok? > > -- > Jeff >
