'not equal' (<>) in combination with 'or' does not work?

[#1]

SQL SELECT * FROM Periodecomponenten Where cdwerkgever <> '$(Werkgever1)' or cdwerkgever <> '$(Werkgever1)' ;

[#2]

Hi,

What is your source database. If its oracle, you can use the 'Not in' function instead of the 'or' statement as follows:

SQl
Select *
FROM Periodecomponenten
WHERE

cdwerkgever not in (
'$(WERKGEVER1)' ,'$(WERKGEVER2)','$(WERKGEVER4)','$(WERKGEVER5)')

[#3]

In this case it's an SQL database.

[#4]

this should work fine with SQL Server also.

[#5]

The 'not in' function will work fine with SQL server also

[#6]

Thank you for your fast respons Haneesh!