How can I use 'like' keyword with wildcard characters(*) in RecordSelectionFormula of crystal report?

rptdoc = new ReportDocument();
rptdoc.RecordSelectionFormula = " {View1.RefNo}= '" + textbox1.Text + "'";

I need to use 'like' instead of '=' .....

rptdoc.RecordSelectionFormula = " {View1.RefNo} LIKE '%" + textbox1.Text + "%'";

Added the following three things: LIKE % %

I was using Access and it takes * instead of %.....Thanx 4 ur iniative.....:)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.