Delete comment from: Java67
Question 9: find all Employee records containing the word "Joe", regardless of whether it was stored as JOE, Joe, or joe.
SQL>SELECT * FROM Employees
WHERE UPPER(EmpName) LIKE '%JOE%';
Jul 6, 2013, 1:49:56 PM
Posted to Top 10 Frequently asked SQL Query Interview Questions Answers