Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 04, 2008 at 06:31 PM

    Try this

    not ( like "09*")

    Regards,

    Raghavendra

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2008 at 06:23 PM

    In your example are you looking for any field that does not contain (literally) "09*"

    or does not contain "09"

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      If the "09" will always appear in as the first two characters (when it does appear)....simply do this...

      IF "09" = LEFT (,2) then false else true

      Edited by: James Terry on Sep 4, 2008 9:02 PM

  • avatar image
    Former Member
    Sep 10, 2008 at 02:56 PM

    I got this working following the advise above.

    I used "not ( like "09*") " and it worked. This is nothing like the SQL version of this statement like I was thinking.

    Add comment
    10|10000 characters needed characters exceeded