no_case response

[Greg Kowalski]

I solved the problem using:

WHERE str_fld LIKE '\ANew York\Z' no_case

This gives me search identical to using the "=" operator only it is case
insenstive. 

is this correct? 

Greg

-----






Message: 12
Date: Fri, 13 Feb 2004 17:26:38 +0200
From: Ruslan Zasukhin <sunshine at public.kherson.ua>
Subject: Re: no_case question
To: <valentina at lists.macserve.net>
Message-ID: <BC52B94E.2F0CD%sunshine at public.kherson.ua>
Content-Type: text/plain; charset="US-ASCII"

on 2/13/04 5:23 PM, Greg Kowalski at gregkowalski at earthlink.net wrote:

> Hello, 
> 
> I want to make a search using the "=" operator and also have it case
> insensitive.  Using "no_case" doesn't seem to work. Is there a way?
> 
> Also, is "no_case" only for the "LIKE" operator?

Hi Greg,

This is in FAQs.

You need to use BaseObject method