HOW TO USE LIKE Operator IN SQL SERVER.

Total Post:341

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

    Points:2003
    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