Like Function Select Using a Parameter

[TEM3]

In Crystal Reports 8.5, what would be the syntax to use a LIKE FUNCTION formula select?

For example, lets say I had a table of training courses and I wanted to see who attended a particular course. Since my users will probably only know or want to enter part of the course name I want to use a "like *{?course}*" to select the course. I can't figure out the correct syntax, assuming it can be done.

 

[Turkbear]

Hi,
Could be database specific,
so please supply database ,version and connection method.

What have you tried?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[TEM3]

Using it for both Access 2000 and Oracle 9i table reports.

 

[lbass]

Using a parameter, you would set it up like this:

{table.coursename} like "*"+{?CourseName}+"*"

Go to report->selection formula->record and enter it there. This assumes that you are not allowing multiple values.

-LB