get records Without like operator

hi,

Please try

SELECT * from tblEmployee where PATINDEX('%S%',Ename)>0

WILL GIVE YOU THE SAME AS LIKE.

Hope it helps.

Thanks.

0

SELECT * from tblEmployee where left(Empname,1)='s'

SELECT * from tblEmployee where left(Empname,2)='sa'

SELECT * from EmployeeCredentialDetail where substring(LoginName,1,1)='0'

SELECT * from EmployeeCredentialDetail where substring(LoginName,1,2)='01'

0

Hi,

Here is the link -

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

0

You can use CharIndex function. Google for details.

0