Query problem with commas in field

[Torgos_12]

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.

[asterix]

Hi,

what makes you think the commas are the problem?
Your query (is probably slow) seems fine.

[danfran]

Torgos,

I'm not discounting the fact that something strange might be going on here, but I must first suggest that you output the SQL statement that you are passing to SQL Server directly on the webpage from which it is being executed. Specifically, put an unusual character around the statement so that you can see whether or not there is a SPACE character before the last percent sign.

It could simply be a matter of not trimming the var that holds "Some Company".

This will return zero records:
select * from table where Customer LIKE '%Some Company %'

let us know!

-Dan

[asterix]

Dan, that is excellent advice.

[Torgos_12]

And also extremely accurate - that was indeed the problem.

Thank you very much to all for the advice.

Rob.