Suffering the same issue here, and can't get it resolved.  Would be good to know if anyone has got this working

Yes, what I was meaning why does the query using LIKE not work (i.e. it doesn't return any rows, even though it should, and I can prove this by querying via SSMS).  I ran the second query from Ensemble just to see if there was something fundamentally wrong with my query, this would prove there is not, as the query using NOT LIKE returns the rows I would expect it to.

What I am questioning is why the query which just uses LIKE does not return any rows when it should from Ensemble.