sql not like wildcard code example

Example 1: ST_SQL is not like

SELECT * FROM Student
WHERE FirstName NOT LIKE '%B%'

Example 2: sql where value like a or b

-- example
SELECT Id, ProductName, UnitPrice, Package
  FROM Product
 WHERE ProductName LIKE 'Cha_' OR ProductName LIKE 'Chan_'