select * from table_Name where lower(name)=lower('aaa') ; select * from table_Name where upper(name)=upper('aaa') ;