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