lower(); upper(); select lower(test_name)=abcde from test_table; select upper(test_name)=abcde from test_table;