which is more efficent not in(' ',' ') or <>" " and <>" "

[Wayne Anderson]

I'm trying to make a query more efficient working with large tables. Which
would be the more efficent use?
not in(' ',' ') or
<>" " and <>" "
or possibly another formula or combination...

Thank you,

Wayne Anderson

 

[John Spencer]

It probably doesn't make any difference. The engine that runs the query
will probably optimize them both the same.