How do I compare strings with no case? For example, a string might be "Business" in the database, but I'd like to find it by "business". I've tried the LIKE operator and lower() on both the column name and the value, but those don't seem to work. Any suggestions?

lower() work for sure. Whitch DB ?

Lower() or upper() shoud work absolutely fine, I'm using upper() on oracle in production code and it runs without any problems.