How To 'OMIT' In SQL

[Chuck Pelto]

On Jan 12, 2007, at 11:24 AM, Ruslan Zasukhin wrote:

> On 12/1/07 7:55 PM, "Chuck Pelto" <cbpelto at pcisys.net> wrote:
>
>> In FMP, there is a functionality to omit certain records based on
>> search criteria.
>>
>> How does one achieve that sort of functionality in SQL with V4RB?
>
>     WHERE NOT(f1 = 3)

Then, when one had a situation where there were multiple criteria for  
omitting it would read...

WHERE NOT(f1 = 3) AND NOT(f2 = X)

Or would it read....

WHERE NOT(f1 = 3) AND (f2 = X)

Or would it read....

WHERE NOT((f1 = 3) AND (f2 = X))


Regards,

Chuck