OK so I have now got this working after a lot of googling etc.  In the registry at Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Internet Explorer\Main\FeatureControl\FEATURE_BROWSER_EMULATION ensure you have a REG_DWORD entry for eclipse.exe with a  Decimal value of 11001

Hopefully this should help anyone facing this issue.

Apologies, as I have meant to come back and update.

So it was really pretty simple, and Mike Dawson was spot on "Try LIKE 'PARA%' (All upper case)".

This was indeed the issue,  what I hadn't realised was that the LIKE would be  case sensitive.  Feeling more than a little foolish I didn't spot this myself, but you know how it is sometimes when you are  blind to the obvious when you are in the zone.

Thanks all for your input.

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.