like and and sql not working code example

Example: SQL is not like

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