Palmer_Admin
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
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
thank you
ToText({yourfield}) like "*9*"
AND
ToText({yourfield}) <> "999"
mlmcc
AND
ToText({yourfield}) <> "999"
mlmcc
{YourField} LIKE "*9*"
ANother way would be
InStr({YourField},"9") > 0
mlmcc