db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dan Scott" <deni...@gmail.com>
Subject Re: case-insensitive
Date Thu, 19 Jul 2007 04:28:42 GMT
On 18/07/07, Onur Aslan <onur@0nur.net> wrote:
> Hi. I am using Apache Derby and i am newbie. I have a problem. I am
> select some rows with:
>
> "SELECT * FROM parcalar WHERE parca_no LIKE '%onur%'"
>
> But this query is select case-insensitive parca_no values. Like if
> parca_no = Onur this query isn't select this row. I want to disable case
> insensitive. How can i do this?
>

"SELECT * FROM parcalar WHERE LCASE(parca_no) LIKE '%onur%'"

... should do the trick, although it may be slower than you want.

-- 
Dan Scott
Laurentian University

Mime
View raw message