>Unfortunately my software choice is limited to ASP(VBScript,JavaScript) only.
>BTW, your version of sentence (with '^') doesn't caused an error but returning the wrong recordset while sentence without '^' works fine.
There could something different in the environment. As for me, I am using the VFPOleDB for the provider under VB.NET in .NET Framework 2.0.