NOT LIKE excludes desired records plus records with NULL in the field

[hopi]

Hi,

Using this condition: AND instructions NOT LIKE '%RESUBMIT%'

I successfully exclude records where the 'instructions' field contains the word 'RESUBMIT' but it also excludes records where the 'instructions' field contains NULL. Why and how can I get around this?

Thank you.

hopi

[pbmods]

Heya, hopi. Welcome to TSDN!

Add [code=sql]OR `instructions' IS NULL[/code]