'Not In' Syntax for Array

[crogers111]

CR XI
SQL
{Table.ZipCode} is a string

I'm trying to exclude a group of zip codes within my selection criteria and can't get the syntax correct.

Sample of the code that INCLUDES a few of the zip codes (I actually have to exclude approx 30 zip codes):

{Table.ZipCode} in ["95410","95415", "95417", "95418", "95420"]

when I use the following, I get a 'boolean is required here' error:

not({Table.ZipCode}) in ["95410","95415", "95417", "95418", "95420"]

What is the correct syntax to EXCLUDE a group of zip codes that are stored as strings within the Selection Criteria ?

 

[MCuthill]

crogers,

Very close! change your formula to as follows:

not({Table.ZipCode} in ["95410","95415", "95417", "95418", "95420"][COLOR=red][b])[/b][/color]

Cheers!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."

 

[crogers111]

ah, of course. Thanks !