Dynamic where clause

[sonaliak]

What is dynamic where clause ?? Where is it used?

[chrisrlong]

My best guess is that you are talking about the WHERE clause for a Dynamic SQL statement. A dynamic SQL statement is one that you build 'on the fly', often dependant upon user input. For example, the user is on a Search screen with a bunch of control. Based on what values are filled in, you build the appropriate SQL statement including the WHERE clause.

- Chris