Link to home
Start Free TrialLog in
Avatar of Becky Edwards
Becky EdwardsFlag for United States of America

asked on

Want to include data that starts with a specific number

I have a field that I want crystal to evaluate, and if the field starts with the number 9, then I want to include that data.  I know where to put this code - in the section expert under suppression, I just don't know how to say it in crystal language.  Below is my attempt which did not work.  Please help.

and(totext({CLARITY_EAP.PROC_CODE}) like "9")
ASKER CERTIFIED SOLUTION
Avatar of nap0leon
nap0leon

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Becky Edwards

ASKER

Wow - that worked!!! Thanks!
Avatar of Mike McCracken
Mike McCracken

You could also use

and (totext({CLARITY_EAP.PROC_CODE}) StartsWith "9")

or

and (Left(totext({CLARITY_EAP.PROC_CODE}),1) = "9")

mlmcc