Database Query - Support for "NOT LIKE"

OL Connect Professional Workflow
1

I need to exclude several specific items that contain a unique string as part of the value.
The easiest method is to enter in the exclusions.

WHERE [InputProcess] NOT LIKE "%BOT_%" AND [InputProcess] NOT LIKE "%INV_%" AND...

It appears that the Database Query plugin does not support the “NOT LIKE” operator, but I’m able to run the same script in SSMS.

2

Hi,

Could it be that the % needs to be doubled in the syntax so the parsing doesn’t consume it?

Regards,

3

That make sense. Completely forgot about the %. Thanks