SQL: Like and NOT LIKE?

Question

SQL

Standard task: in the Product table, find models that consist only of numbers or only of Latin letters (AZ, case insensitive).
Output: model number, model type.

Correct answer:

SELECT model, type FROM Product
WHERE model NOT like '%[^0-9]%' OR upper(model) NOT like '%[^A-Z]%'

I can't understand why NOT LIKE and not just LIke in the query? Isn't NOT like '%[^....] just LIKE as a double negative?

Answer 1

LIKE doesn't work with regular expressions. This is your mistake

Answer 2

Just show the client examples of great sites from his competitors.

Answer 3

Can you solve some customer problems by creating a personal website or just want to make money on them?