<p>Hi All,<br>
<br>
I am using Actuate 8 for reporting.<br>
I want to filter the query based on input parameter using LIKE clause.<br>
My query in the report is (aid is the input parameter that I am passing as an input)</p>
<p> </p>
<p>select date,code,name from from acctount where accountid like :aid</p>
<p> </p>
<p>And let consider a account id -ABC123</p>
<p>when I am giving the entire accountid(ABC123) the report is working fine, but when I give the middle part of accountid(BC12), the report is not fetching any rows.</p>
<p> </p>
<p>can somedody will help me with this?</p>
<p> </p>
<p>Thanks in advance</p>
<p> </p>
<p>Regards,</p>
<p>Siva Gv.</p>
