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?