3

Possible Duplicate:
Make Oracle SQL LIKE query case insensitive

I want to do string comparison in SQL-Statements that ignore case. Currently we use something like upper(field) like upper(anotherField) and something like that. However this approach is known to fail the Turkey test, isn't it? How to do it the right way?

Community
  • 1
  • 1
Fabian Barney
  • 14,219
  • 5
  • 40
  • 60
  • Are the answers given [here](http://stackoverflow.com/questions/389535/compare-strings-in-oracle) of any help? – wolφi Dec 12 '12 at 10:23
  • @WolfgangFleischmann Not really. Maybe [NLS_COMP](http://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams120.htm) mentioned there will be helpful here. But I am pretty unsure ... – Fabian Barney Dec 12 '12 at 10:59

0 Answers0