Skip to Content
avatar image
Former Member

Query Generator - Multiple Values for Does not Contain

Hello,

I'm trying to add another value to our does not contain query below, but I keep getting an error. It only works with the one value I have below. I would also like the report to not include ItemCode that does not contain 'PR%%'

WHERE T0.[ItemCode] NOT Like 'PK%%'

Thank you for your help.

Regards,

Kurl

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 24, 2017 at 09:31 AM

    Hi Kurl Peter Dapula

    Use "And" condiition

    T0.[ItemCode] NOT Like '%%PK%%' and T0.[ItemCode] NOT Like '%%PR%%'

    Regards:

    Balaji.S

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 24, 2017 at 10:34 AM

    Hi,

    Please share error message here to check.

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded