joe. Search

find all Employee records containing the word "Joe", regardless of whether it was stored as JOE, Joe, or joe.

Answer

SELECT * from Employees WHERE upper(EmpName) like upper('joe%');

Workspace

Report Error

Subject: SQL