>I have a two dimensional array - site,security. I want to create a two dimensional array of - site,security - for security = '2'.
>
>Thanks
>
>Brenda

Try something like this...

CREATE CURSOR temp (Site c(20), security C(1))
INSERT INTO temp FROM ARRAY arr1
SELECT * from temp WHERE security='2' INTO ARRAY arr2
Use IN temp