Query syntax help

  • Thread starter Thread starter Claudi
  • Start date Start date
C

Claudi

Hi
I need to write a query that will show me the records that is
different from "YES" but I forgot what is the syntax...
Can someone help me?


SELECT *
FROM Table1
WHERE Quotas different "YES";


Cheers,

CLaudi
 
Claudi said:
Hi
I need to write a query that will show me the records that is
different from "YES" but I forgot what is the syntax...
Can someone help me?


SELECT *
FROM Table1
WHERE Quotas different "YES";


Cheers,

CLaudi
Click to expand...

WHERE Quotas <> "YES"
 
Brian said:
WHERE Quotas <> "YES"
Click to expand...

Note that if Quotas is a Yes/No field, the word "Yes" isn't actually stored
there: rather, the value -1 is stored for True (Yes), and 0 for False (No),
so you'd need to use

WHERE Quotas <> True
 
Douglas J. Steele said:
Note that if Quotas is a Yes/No field, the word "Yes" isn't actually stored
there: rather, the value -1 is stored for True (Yes), and 0 for False (No),
so you'd need to use

WHERE Quotas <> True
Click to expand...

Good point, I took the post literally, but that may not have been what the
OP intended.
 
Back
Top