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?

Thanks

Rob.