Which WHERE clause can you use with a SELECT statement to perform a case-insensitive search for rows containing the first name Marco?
A) WHERE FIRST_NAME = UPPER('MARCO')
B) WHERE FIRST_NAME = LOWER('MARCO')
C) WHERE LOWER(FIRST_NAME) = 'MARCO'
D) WHERE UPPER(FIRST_NAME) = 'MARCO'

Question

Quizplus · Accepted Answer

The WHERE clause using UPPER(FIRST_NAME) = 'MARCO' converts all first names to uppercase before comparing, ensuring a case-insensitive match with 'MARCO'.

Which WHERE Clause Can You Use with a SELECT Statement