List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 4 2000 3:46am
Subject:Re: making REPLACE case insensitive
View as plain text  
At 6:59 PM -0800 2000-02-03, Mark Maggelet wrote:
>the column is a TEXT which is case-insensitive for sorting and comparison,
>but REPLACE seems to match things case-sensitively.


That will happen if your TEXT column is not a PRIMARY KEY or UNIQUE
index.  Is it?


>
>***********************************************
>
>On 2/3/00 at 6:11 PM Paul DuBois wrote:
>
>>At 4:02 PM -0800 2000-02-03, Mark Maggelet wrote:
>>>hi there,
>>>Can someone suggest a way to make Replace() be case insensitive?
>>
>>
>>Make your columns case insensitive.
>>
>>--
>  >Paul DuBois, paul@stripped


-- 
Paul DuBois, paul@stripped
Thread
making REPLACE case insensitiveMark Maggelet4 Feb
  • Re: making REPLACE case insensitivePaul DuBois4 Feb
    • Re: making REPLACE case insensitiveMark Maggelet4 Feb
      • Re: making REPLACE case insensitivePaul DuBois4 Feb
        • Re: making REPLACE case insensitiveMark Maggelet4 Feb
          • Re: making REPLACE case insensitivePaul DuBois4 Feb