[solved] – Question 76378

Table CUSTOMER has all customers, and it has a column LASTNAME for the Customer’s last name. What statement below would return all customers whose last name begins with ‘EST’?

SELECT *

FROM CUSTOMER

WHERE LASTNAME LIKE ‘EST%’

SELECT *

FROM CUSTOMER

WHERE LASTNAME = ‘EST%’

SELECT *

FROM CUSTOMER

WHERE LASTNAME = ‘EST’

SELECT *

FROM CUSTOMER

WHERE LASTNAME = ‘EST’

OR LASTNAME = ‘ESTA’

Expert Answer

---