Extract rows where data contains specific word

[GAPSAM]

HI
Have 170000 row database. Approx 100000 rows have data which contains the
word DUMMY.
Want to run a query showing all rows which DO NOT contain DUMMY

Tried in the query builder:
<>"DUMMY""*"
<>"DUMMY*"
<>"DUMMY%"
<>"DUMMY""%"

No luck

Went into the SQL builder and tried:
Not in 'DUMMY%'
Not Like 'DUMMY%'

I think I am being dim as I am sure this is an easy query - can anyone help
please?
Sam

 

[Ofer]

Use Like

SELECT FieldName FROM TableName WHERE FieldName Not Like "*DUMMY*"

 

[GAPSAM]

That works - thanks

Use Like

SELECT FieldName FROM TableName WHERE FieldName Not Like "*DUMMY*"