I am using a statement like the following:
select * from table where Customer LIKE '%Some Company%'
It works just fin in SQL Query Analyzer but through ADO web connection it will not return a row where the Customer field is:
Some Company, Another Company, Acme, ABC Corp
It seems to be the commas that are causing the problem - any way to resolve this?