Not in list

[Enea]

When I wish to say: return all the records expect a and b for example.

Do I use Not in List?
if yes, how do I type the values?
"a", "b"
'a', 'b'
"a"; "b"
?

 

[skrandel]

Are you asking a BO question or a SQL quesiton?

Not in list is the way to do this.

In SQL: not in ('a','b')

In BO specify the parameters using a comma or semi-colon as a separator. But, be careful. a,b is OK. a, b is not.

Steve Krandel
Symantec