Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Not Like statement in Crystal?

In SQL server there is a statement that goes along the lines of (field1) not like '09%'

In Crystal Reports there is a statement "Like". Is there any statement in Crystal that is "Not Like"?

I'm trying to get a wildcard of 09 to work in Crystal so far I have......

(field1) <> "09*"

But it needs to be something like the following ........

(field1) not like "09*"

Does Crystal have a Not Like statement? What are my choices if Crystal does not have that statement?

Thanks

Former Member
replied

Try this

not ( like "09*")

Regards,

Raghavendra

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question