Case sensitivity with indexes on DB2

[Anon]

Lately, our company migrated data from ACCESS database to DB2. There is one problem we can't figure out. It has to do with indexes. We didn't have to bother with case sensetivity while using search engine on Access . But when it comes to DB2, it seems to have a problem, and so far this problem appears only while we search on index fields.
If cases do not match, it wont turn(find) the record at all
Is there any way I can fix this issue? I would appreciate your response.

Most Sincerely

Rudina Xhema

[[deleted]]

This has exactly nothing to do with indexes, it is simply crappy old Access that is not case sensitive.

in DB2, you should convert both strings to lowercase or both strings to uppercase before you compare them, like this:

SELECT *
FROM table
WHERE LOWER(field) = LOWER("your string here")

---

A forum, a FAQ, email notification, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/

[Anon]

Dear Vincent,

I appreciate your response very much. I have one more question please. Can this select statement be a subquerie as a criteria and what do I write instead of ("your string here")? Thank you again

Rudina