like syntax in sql
WHERE CustomerName LIKE 'a%' --Finds any values that start with "a" WHERE CustomerName LIKE '%a' --Finds any values that end with "a" WHERE CustomerName LIKE '%or%' --Finds any values that have "or" in any position WHERE CustomerName LIKE '_r%' --Finds any values that have "r" in the second position WHERE CustomerName LIKE 'a__%' --Finds any values that start with "a" and are at least 3 characters in length WHERE ContactName LIKE 'a%o' --Finds any values that start with "a" and ends with "o" (Like) Operator for partial searches using wildcard '%' and '_' For Example: Select * From Employees Where last_name LIKE '_a%';
