CLOSE DATABASES all clear oCon=CREATEOBJECT("ADODB.Connection") oCon.Open("Provider=SQLOLEDB.1;Integrated Security=SSPI;"+; "Persist Security Info=False;Initial Catalog=Northwind;Data Source=(local)") oCon.Execute("SET ANSI_PADDING OFF") oCom=CREATEOBJECT("ADODB.Command") oCom.ActiveConnection=oCon oCom.CommandText="select * from Customers where CustomerID like ?" ?"Try datatype provided by oCom.Parameters.Refresh()" oCom.Parameters.Refresh() ?oCom.Parameters.Item(0).Type,oCom.Parameters.Item(0).Size oCom.Parameters.Item(0).Value="M%" oRS=CREATEOBJECT("ADODB.Recordset") oRS.Open(oCom,,,-1) count=PrintRecordset(oRS) ?"Amount of records", count oRS.Close() ? ? "Change the data type to adVarChar." oCom.Parameters.Item(0).Type=200 && adVarChar oRS.Open(oCom,,,-1) count=PrintRecordset(oRS) ?"Amount of records", count return FUNCTION PrintRecordset (oRS as ADODB.Recordset) LOCAL count count=0 DO WHILE !oRS.EOF ?oRS.Fields.Item(0).Value oRS.MoveNext() count = count + 1 ENDDO RETURN count ENDFUNCThus, it is not a VFP BUG, however, I do understand that this doesn't really matter for a developer who is facing the problem.