Dynamic SQL query

Hi,
I need to execute a query with n number of condition. I don’t know the number of conditions that will be set.
I read that i can create a Dynamic SQL. Can you show me an example?

Thanks,
Regards
Fabio

Please refer to page number 112 in the JDBC adapter user’s guide (http://techcommunity.softwareag.com/ecosystem/documentation/webmethods/adapters_estandards/Adapters/JDBC/JDBC_6-0-3/JDBC%20Adapter%206.0.3/webMethods%20JDBC%20Adapter%20User%27s%20Guide%206.0.3.pdf). It has a simple query implemented using Dynamic SQL adapter template.