Hi, Kevin-

>That's sorted it - not sure why it was sent to ON though.....hmmm. Would you believe I've never uses ANSI until now (because obviously it defaults to OFF).

Glad that did the trick. BTW, I just checked the help file to see if the default for SET ANSI is ON for the OLEDB provider, and it doesn't mention it, that I've found.