I have a problem using this line:
Code:
Dim cn as rdoConnection
Dim rs as rdoResultset
Dim SQL as string

Cn.Connect = "Database=d:\code\tablas;" & _
          "Driver={MERANT 3.50 32-BIT FoxPro 3.0 Database (*.dbc)}"

SQL = "SELECT * FROM contra WHERE centro LIKE '245*25530'"
Set rs=cn.OpenResultset(SQL, rdOpenKeyset, rdConcurValues)
And the rs.RowCount is equal to ZERO! And if I change the 'SQL = ...' line as follows:
Code:
SQL = "SELECT * FROM contra WHERE centro LIKE '2452533425530'"
The rs.rowCount is equal to 8.

Why the LIKE clause is not working with the comodin (*)?

I'm using the RDO object and a MERANT ODBC dirvers (DirectData Connect ODBC 3.50 for Windows 9x-NT).

I'll thank every help.

Ulises

[This message has been edited by Tonatiuh (edited 08-10-1999).]