get records Without like operator

Question

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??

Vishal Jadav · Answer

hi Please try SELECT * from tblEmployee where PATINDEX('%S%'  Ename)>0 WILL GIVE YOU THE SAME AS LIKE. Hope it helps. Thanks.

Sanjeev Kumar · Answer

SELECT * from tblEmployee where left(Empname1)='s' SELECT * from tblEmployee where left(Empname2)='sa' SELECT * from EmployeeCredentialDetail where substring(LoginName11)='0' SELECT * from EmployeeCredentialDetail where substring(LoginName12)='01'

Midhun T P · Answer

Hi Here is the link - http://www.c-sharpcorner.com/blogs/select-employee-name-start-with-a-without-using-like-operator1

Nitin Sontakke · Answer

You can use CharIndex function. Google for details.