SQL returns no records, but should

[Scott Runkel]

WORKS PERFECTLY!

Thanks again. I have no idea why it works, or even what "lower" is supposed to 
do, but I'm extremely happy.

-SR

Scott Runkel
Director of Technology
Hypix Media, Inc.
503-722-2123
----- Original Message ----- 
From: "Thorsten Hohage" <thohage at objectmanufactur.com>
To: "Valentina Developers" <valentina at lists.macserve.net>
Sent: Friday, July 06, 2007 12:49 PM
Subject: Re: SQL returns no records, but should


>
> On 2007-07-06, at 21:34, Scott Runkel wrote:
>
>>> I.e. this line _could_(!) be a solution
>>>
>>> select * from oc_contact where lower(idname) like '%r,%h%'
>>
>> Good idea, but '%MOST%likely%'  and '%most%likely%'  still return  no records 
>> at all.
>>
>> Also tried various combos like 'MOST likely', '%MOST likely', "most  likely%' 
>> etc with different capitalization and location of the %.
>
> but the important point is to use the lower() - function on the  column side 
> of the expression
>
> regards
>
> Thorsten Hohage
> --
> objectmanufactur.com - Hamburg,Germany
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>