Hi, I am currently using Crystal Rpt 9 on my java web application.
I need to implement a search criteria which will take in a parameter and do a partial search from the database.
the sql may go like this
'select * from biodata where name like '%tan%'
I use the search expert to generate the sql and I find that it can only create a beginning with or end with.. I couldn't find one using containing even though I use the condition 'like' from the drop down condition and the sql query will show something like this.
'select * from biodata where name like 'tan'.
Can anybody advise on this?

Thanks.
Yaoying