Home > DeveloperSection > Forums > HOW TO USE LIKE Operator IN SQL SERVER.
Ankit Singh

Total Post:341

Points:2389
Posted on    December-19-2015 4:24 AM

 Database SQL Server  SQL  SQL Server 2008  SQL Server 2012 
Ratings:


 1 Reply(s)
 466  View(s)
Rate this:
I want to use like Operator  in sql server how to use this.please help me.


aditya kumar Patel

Total Post:250

Points:1782
Posted on    December-19-2015 4:28 AM

The LIKE operator is used to list all rows in a table whose column values match a specified pattern. It is useful when you want to search rows to match a specific pattern, or when you do not know the entire value. For this purpose we use a wildcard character '%'.

SELECT * FROM Customer

WHERE CustomerName LIKE 'ad%';

 


Don't want to miss updates? Please click the below button!

Follow MindStick