Skip to Content
0

Query Generator - Multiple Values for Does not Contain

Mar 24, 2017 at 08:35 AM

32

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Balaji Selvaraj Mar 24, 2017 at 09:31 AM
0

Hi Kurl Peter Dapula

Use "And" condiition

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

Regards:

Balaji.S

Share
10 |10000 characters needed characters left characters exceeded
Nagarajan K Mar 24, 2017 at 10:34 AM
0

Hi,

Please share error message here to check.

Regards,

Nagarajan

Share
10 |10000 characters needed characters left characters exceeded