D365 FO Dual write query

Hi,

I need to use not equals operator in dual write query. <> && != are simply not working can anyone please suggest me some other approach.

Thanks!