case insensitive search sql

If you want to search for the following words: ‘Hello’,’hello’,’HEllo’ then you may think about using UPPER or LOWER, but there is an easier way. All you have to do is create an index on your column you want to