Yes this is possible, there are two ways to use parameters embedded within SQL statements. Example: SELECT col1, col2, col3 FROM table1 WHERE col1= 2 First option, let's say you want to substitute the value 2 in the where clause create a parameter and assign value 2, for instance parameter named pValue set to 2, the statement would then be changed to the following: SELECT col1, col2, col3 FROM table1 WHERE col1= $P{pValue} This would then dynamically use the value in the parameter to match in the where statement. More specific to your question, let's say you wanted to build a dynamic where statement, there is another mechanism which instead of doing parameter substitution it wil actually parse the string before exection. Create parameter pWhere (or whatever you want) and for the expression set to "WHERE col1 = 2" or whatever you want your where statement to be and then the change the statement to: SELECT col1, col2, col3 FROM table1 $P!{pWhere} The $P! will parse the string into SQL statement before exectuting, this is how you woudl get what you describe, having different where conditions exectued from parameters.