I have a table t with 2 columns: employee name and employee id. how do i display all the employee names ?

Question

ending with s without using the LIKE operator?

Answer 1

I think you should give more details about your task. What pkg you are using what result you want. Let us know your purpose.

Answer 2

Assuming MySQL:

SELECT name FROM Employees WHERE RIGHT(name,1)='s';

RIGHT isn't anywhere near as efficient as LIKE is though. RIGHT also isn't ANSI SQL, and the function may be slightly different, or have no equivalent at all, on other RDBMS's.