Cindy/Nancy

DOH!!

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).

Thank you ladies
Kev

>>Hi
>>
>>I'm trying to execute a SELECT statement using the VFPOLEDB provider from .Net, but unfortunately it acts as if EXACT is set to on, I've tried issuing a Command of "SET EXACT OFF" after opening the connection, but the SELECT always obtains the exact matches.
>
>SELECT uses SET ANSI, not SET EXACT. However, the default for SET ANSI is OFF.