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%');