like not working in sql code example

Example: SQL is not like

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