So a little bit of backstory is I am working with a program that uses SQL filters to sort/rate freight bills. The problem is that it can only be 256 characters long. So what I was trying to do was using the built in select statement group like rates for various zip codes.

```
select * from tlorder
where blank = blank
and.......

```

Thats the default SQL so I added the following: Q\_INT is a custom stored procedure.

```
Q_INT(start_zone) between 55001 and 56799 
and (Q_INT(end_zone) (between 55001 AND 56799
OR Q_INT(end_zone) between 58001 AND 58299
OR Q_INT(end_zone) between 57001 AND 57299
or Q_INT(end_zone) between 50301 AND 50399
or Q_INT(end_zone) between 51001 AND 51399
or Q_INT(end_zone) between 54001 AND 54099
or Q_INT(end_zone) between 54601 AND 54899)

```

And this works only its to long so is there a way to set 2 arrays and use that in the end\_zone part? Like...

```
and Q_INT(end_zone) between Array[1,12,23] and Array[11,22,33]

```

Thanks.