SQL: column <> '%TEST%' does not work, why?

Question

I do not understand why following code does not work?

SELECT [column1], [column2]
FROM table where Column1 <> ('%TEST%')
ORDER BY 1

I want to have all rows where Column1 does not contain TEST

Thanks

Answer 1

Use LIKE operator with Wildcards %:

SELECT [column1], [column2] 
FROM table 
WHERE Column1 NOT LIKE ('%TEST%') 
ORDER BY 1