ODBC and LIKE gives weird query

You may want to try upgrading to 3.0.4, as there were a few fixes to the database library in each version since 3.0. As far as I can tell, the output should look something like the following:

Code:

SELECT cats FROM pets WHERE name LIKE 'a!%' {escape '!'}

For reference:
https://msdn.microsoft.com/en-us/library...85%29.aspx

Bonfire

Practical CodeIgniter 3
CodeIgniter Testing Guide