how to do case-insensitive search

[Ruslan Zasukhin]

On 12/11/09 3:06 AM, "william humphrey" <bill at bluewatermaritime.com> wrote:

Hi William,

This is a FAQ.

Please read about
    db.Collation( kStrength ) = kSecondary

> I am trying to do a case insensitive search. Valentina "like" searches are
> case sensitive.
> 
> Sometimes I like that but sometimes I want to do a case insensitive search.
> How do I do that?
> 
> select ID, Name
> from myTable
> where case-insensitive(say) like binary '%J%'
> 
> target result
> 
> (1) Jane
> (2) jane

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]