Hi everyone..
I have a tblEmployee table with Eid,Ename,Salary,Did columns.
I want to get Ename that contains 'S'.
I have used a query i.e SELECT * from tblEmployee where Ename like '%S%'
In an interview they asked me to do it without like operator.
Can anyone please tell me, how to do it??