I have a field name in my table. It contain a value like this "Mike".
suppose the user will search by name like this
"miKe","mIKe","MIKE". what ever possible cases. I want to display the message wheather this name is exist or not in the table.
select * from test1 where Name like lower('Mike%') or Name like upper('mike%').
but this query is not returning the value. what is wrong in it and how to display the valve?