NOT LIKE excludes NULLS

Rauf Sarwar · *nix forums Guru Joined: 03 May 2005 Posts: 353

Randy Harris wrote:

Randy Harris · *nix forums Guru Wannabe Joined: 23 Apr 2005 Posts: 202

I'm doing a query, using NOT LIKE, but not getting the results I would like.

WHERE myfile NOT LIKE 'VAR%'

I would like for it to return ALL records that don't begin with VAR, but it
excludes records with a NULL value. I'm really hoping that there is a
simple work around that does not involve adding an OR clause. The
application that creates the query makes it really tough to add ORs.

It will do

( clause and clause) or (clause and clause)

but won't do

clause and (clause or clause)

and there are a bunch of clauses.

Any suggestions would be appreciated.

--
Randy Harris
(tech at promail dot com)

Google