hello, i have a query which selects some persons from a database. now i found out that i have to generate a dynamic where clause. the problem is that i need to generate a dynamic query which has more than 27.000 characters. I did such queries before but with no more than 2000 characters. can you please give me a hint of how this is best done? thanks, bogdan Able was I ere I saw Elba !