HOW TO USE LIKE OPERATOR IN SQL SERVER.

Ankit Singh

Total Post:341

Points:2389
Posted by  Ankit Singh
 810  View(s)
Ratings:
Rate this:
I want to use like Operator  in sql server how to use this.please help me.
  1. aditya kumar Patel

    Post:254

    Points:1810
    Re: HOW TO USE LIKE Operator IN SQL SERVER.

    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%';

     

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!