feature request: case insensitive indexed searches

[Ruslan Zasukhin]

On 4/17/04 9:55 AM, "michael geary" <listmail at gearyweb.com> wrote:

Hi Michael,

> Hi Folks,
> 
> i've got a varChar field that is indexed, and I want to do
> case-insensitive searches. I know that I can do these with LIKE, but
> that doesn't use the index. Is there really no way to do something
> like:
> 
> WHERE firstname = 'ruslan' no_case
> 
> and get the benefit of using the index?

Yes, for this you should use BaseObject methods

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------