how to do case-insensitive search

[Thorsten Hohage]

Hi,

what is about using the "lower()" function?

select * from testTable where lower(firstName) like ('%william&')



On 2009-12-11, at 05:56, Ruslan Zasukhin wrote:

> 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


regards,

Thorsten Hohage
-- 

Valentina Technology Evangelist
generic objects  GmbH - Leiter Solution Center Nord