On 18/07/07, Onur Aslan <[EMAIL PROTECTED]> 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
