Thank you very much Keith for your concern, I will look into this.

I am also trying to do a "UNION ALL" but not sure how to do it dynamically like...if a user passes 2 states it should do union all between 2 result sets and if he passes 3 states then it should do union all between three result sets.

thanks again Keith.