SQL Outbound Adapter - Query not returning data as expected
I have an operation which uses the SQL outbound adapter to query a data source set up using a system DSN on the server which uses the Intersystems ODBC35 driver (this is a cache db hosted elsewhere).
Whenever Ensemble runs the following query:
WHERE c_drugfull LIKE 'Para%'
No data is returned, however running the same query via SQL Server Management Studio, all expected rows are returned.
Also if I run the following via Ensemble:
WHERE c_drugfull NOT LIKE 'Para%'
This returns all the rows as expected
It's probably obvious to someone what the issue is, any help much appreciated.