When I use ADODB in VBA to query an Access table for a string, I use syntax such as SELECT * FROM CUST WHERE COMPANY_NAME = "JOHN'S SERVICE COMPANY"... This works fine when I'm querying an Access Database. However, when I try to use this syntax to query a table on SQL Server 2008 R2, it returns a syntax error. When I change the delimiting double quotes and replace them with single quote, it works fine... providing there isn't a single quote within the COMPANY_NAME, as there is in this case. The problem is that I need the query to work even if the data contains one or more single quotes. Is there a setting on SQL Server that I can set to make it accept the double quote delimiter convention? Thanks, Eddie