Skip to Content
Former Member
Sep 04, 2008 at 06:19 PM

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?