Hi Folks
How do I pass a parameter containing an apostrophe (as in D'Artagnon or O'Neill) to SQL Server using the OLEDB driver?
Within SQL Server, it's no problem, you simply double the apostrophe (D''Artagnon). This doesn't work however via the OLEDB driver.
TIA
Justin