Thanks for the reply, will test this and let you know. My concern with thIs is it seems as if it will retrieve all the values in the table making my parameter dropdown list very long. Is there a way that we could use distinct?