SQL returns no records, but should

[Thorsten Hohage]

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