In order to use a LIKE operator, you need to augment your query via the scripting layer to include the LIKE clause. The LIKE clause requires Wildcard characters (i.e. %) to execute. In order to wrap a parameter in wildcard characters you would need this query to read as follows in the Data Set Editor:
field LIKE '%?%'
<br />
The single quotes will prevent the dynamic substitution of the parameter value targeted for the question mark placeholder.<br />
<br />
Insterad, I removed the entire LIKE clause and instead appeanded it in the Data Set;s beforeOpen script using the following line of code:
this.queryText = this.queryText + " AND CLASSICMODELS.CUSTOMERS.CUSTOMERNAME LIKE '%" + params["pCust"] + "%'";
<br />
This allows the SQL to be properly formatted using the supplied run-time parameter value enclosed in single-quotes. You could eisly wrap this in some conditial clause and only add the like clause when it is needed.<br />
<br />
The attached sample provides all customers
LIKE %Mini%. Change the pCust parameter to alter the results of the query itself.<br />
<br />
The sample is built on BIRT 2.3.2 using the sample Classic Models database. No external dependencies.<br />
<br />
Good Luck!
