Using Like operator in crystal 2008 2

[sap1958]

I have a field as follows
The field name is schoolfield

Example data
Occupational Therapy - RPI
Engineering[Technology] - RPI

I attempted to do a booleon statement as follows
if {schoolfield1}like "-RPI" then true
else if {schoolfield2}like "-RPI" then true
else false

When I tested this, the Engineering[Technology] returned a true value. The Occupational Therapy - RPI returned a false. It should have returned a true also. Where did I go wrong? Did I do the Like statement incorrectly?

 

[LinPro]

Hi Sap

You need to put "*" or "?" in the front of "-RPI". The "*" and "?" are wildcards. "*" for any number of characters and "?" is for one.

L

 

[lbass]

What are you using this boolean for? If you want a selection formula to pick up records with '-RPI', then use a formula like this:

replace({table.schoolfield}," ","") like "*-RPI"

The spaces matter, so I removed them from the field.

-LB