sql query not like text code example

Example 1: sql not contains

SELECT * FROM tbl WHERE tbl.col NOT LIKE '%text%';

Example 2: SQL is not like

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