HOW TO USE LIKE OPERATOR IN SQL SERVER.

Ankit Singh

Total Post:341

Points:2389
Posted by  Ankit Singh
 1027  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:258

    Points:1840
    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%';

     

      Modified On Apr-10-2018 06:41:33 AM

Answer

NEWSLETTER

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