Results 1 to 5 of 5
Feb 2, 2005, 11:49 #1
- Join Date
- Jun 2003
- Toronto, ON, Canada
- 0 Post(s)
- 0 Thread(s)
Query problem with commas in field
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?