How To 'OMIT' In SQL

[Ruslan Zasukhin]

On 12/1/07 8:36 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)

no
 
> Or would it read....
> 
> WHERE NOT((f1 = 3) AND (f2 = X))

Yes

---------

The same condition can be represent in few forms according to Boolean
Algebra. So choose any you like :-)

May happens that some form will be faster of another.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]