SELECT last_name, first_name FROM emp WHERE last_name=’smith’
SELECT last_name, first_name FROM emp WHERE UPPER(last_name)=’smith’
SELECT last_name, first_name FROM emp WHERE last_name=UPPER(‘smith’)
SELECT last_name, first_name FROM emp WHERE LOWER(last_name)=’smith’