HOW TO USE LIKE Operator IN SQL SERVER.

Total Post:341

Points:2389
 1100  View(s)
Ratings:
Rate this:
I want to use like Operator  in sql server how to use this.please help me.
  1. Post:280

    Points:1994
    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!