SQL LIKE Operator

Ranjeet_8
Posted by Ranjeet_8 under Sql Server category on | Points: 40 | Views : 920
1.Query:

SELECT First_Name,City
FROM Employee
WHERE First_Name LIKE 'A%';

Result:

First_Name City
Abhi Noida
Ashu Delhi


2.Query:

SELECT First_Name,City
FROM Employee
WHERE First_Name LIKE '%A%';

Result:

First_Name City
Abhi Noida
Ashu Delhi
Kailash Gurgaon
Krishna UP

Comments or Responses

Login to post response