trying to filter out field with certain string but it also filters out empty strings!

[cherold]

I am so confused. I have a query:

SELECT Songs.SongID, Songs.Title, Songs.Alternative
FROM Songs
WHERE (((Songs.Alternative)<>"UNIQUE"))
ORDER BY Songs.Title;

I was hoping that where clause would filter out rows where the Alternative field had "UNIQUE", but it also filters out all rows where Alternative has nothing.

Example:
Songs Table:

SongID Title         Alternative
1          hello        UNIQUE
2          goodbye      DELETE
3          where        MASTER
4          how     
5          which

Using that query I only get:

2          goodbye      DELETE
3          where        MASTER

Why? How should I be doing this so I get all rows except the one that has "UNIQUE" in it?

[pbaldy]

Try

WHERE Songs.Alternative <> "UNIQUE" OR Songs.Alternative Is Null

[orange]

SELECT Songs.SongID, Songs.Title, Songs.Alternative
FROM Songs
WHERE (((Songs.Alternative)<>"UNIQUE")) or songs.alternative is null
ORDER BY Songs.Title;