Link to home
Start Free TrialLog in
Avatar of Palmer_Admin
Palmer_AdminFlag for United States of America

asked on

LIKE operator in Crystal Reports

Hello,
Quick question: I am trying to use LIKE operator in my Operation field.
Operation - number value
So I want to Supress if Operation has value '9' in it.
I am using inside Format Editor --> Supress --> X2 box for Formula

thank you
Avatar of Mike McCracken
Mike McCracken

You could try

{YourField} LIKE "*9*"

ANother way would be

InStr({YourField},"9") > 0

mlmcc
Avatar of Palmer_Admin

ASKER

Hello MLMCC,
I get this error when I use:
{YourField} LIKE "*9*" - a string is required here

if I use the other command I get this error:
Not enough arguments have been give

thanks

ASKER CERTIFIED SOLUTION
Avatar of JayConverse
JayConverse
Flag of United States of America image

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
JayConverse, is there a way to add exlude Operation "999"? the user came up to me and said that they want Operation "999"

thank you
ToText({yourfield}) like "*9*"
AND
ToText({yourfield}) <> "999"

mlmcc