View Single Post
Old 15 Sep 2013, 15:35
smirkley smirkley is offline
Join Date: Apr 2008
Originally Posted by kh99 View Post
If you're talking about trying the last code you posted above, that won't work because the only way the condition would be true is if pm.folderid was equal to -1 and to 0. If you wanted to do it that way you'd need an OR (and add parens), like:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

But that's actually equivalent to "AND pm.folderid IN (0, -1)", which is what you get by removing the NOT.
Forgot to return to this, but yes you are correct. My attempt didnt work as you suggested. Didnt prune anything in tests.

I will try your suggestion next and report back the results.

Is there a preferred methed? Use the OR or use the AND without the NOT?
Reply With Quote