Today I Learned: collection of notes, tips and tricks and stuff I learn from day to day working with computers and technology as an open source contributor and product manager

View project on GitHub

How to query data where you are unsure of the casing

I often run into the problem of querying for example company names and they can be expressed in a variety of ways.

So I found this example:

where lower(col1) like lower('your_value%')

So what I need to do is something a long the lines of:

select * from company where lower(name) like lower('CompanyName%');

Resources and References

  1. Oracle Communities: “LIKE case insensitivity”