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