SQL LIKE Operator

Posted by Ranjeet_8 under Sql Server category on 8/31/2012 | Points: 40 | Views : 1407

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

Bookmark It

Latest Code Snipptes