Query to Check if PrevRS is falseOR PrevRS false and Where 2

[din2005]

Hi everyone,

How do u form a criteria to check where prevRS is false OR prevRS is true AND Location is not null.

Can this be done in a query or could someone provide me sql for this to get me going.

Thanks

 

[Crowley16]

where ((PrevRS = 'false') OR (prevRS = 'true')) AND not isnull(Location)

--------------------
Procrastinate Now!

 

[PHV]

Another way:
WHERE PrevRS IN ('false','true') AND NOT (Location IS NULL)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244