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

Question

I do not understand why the 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 with Wildcards %:

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

Answer 2

If you want to use wildcards, you must use LIKE :

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

Answer 3

Wildcards ( % ) in SQL should be used in conjunction with the LIKE statement:

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

Answer 4

to try

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

Answer 5

% is a wildcard expression, which is probably the cause; I think you can, if you want to get the% literal, wrap it in square brackets [%], but I will really forget if this is the answer, and sorry if it is not.

If you want to use it so that there is no text test in the column, follow these steps:

where column1 is not like "% Test%"

Answer 6

You need to specify Column1 NOT LIKE '%TEST%' .

Answer 7

Did you mean using like?

where Column1 not like '%TEST%'