Question Mark Lang · Feb 9, 2018 SQL Outbound Adapter - Query not returning data as expected Hi all,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:SELECT lnkdid,c_fastsearch_code,c_drugfullFROM JAC.drug_basicWHERE 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: #Ensemble #SQL 0 7 0 632