I have this error in SQL instruction

[HoffmanGuerra]

Hello community,

     I have this error  and I cann´t  solve it.

     The instruction is in the first image attached.


  Please, some One  can help me?

[EmersonF]

Hi, @Hoffman Guerra try it!

"[ID] = '"&[ItemData.ID]&"' AND [Status] not like 'OK'"​

​​See if this works for you, if this helps you mark as answered

[VivekGoel]

Out of curosity, it seems like you are doing an exact match, and hence using "Not Like" is useless.

Probably you should considering "!= or <>" operator which would consume less memory.

[EmersonF]

Good observation! In fact, the best option would be to use negation <> ​​​​

[HoffmanGuerra]

Hello guys,

        Thanks for your response, I changed to "<>" and it worked!