sql not like A and o code example

Example: ST_SQL is not like

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