LIKE operater -- my job is on the line here!!

I have to get this done by Monday! Please help me
This is how I'm opening the recordset:

Addy.Open "SELECT RefNr From Address WHERE RefNr LIKE '*416*'", cnn, adOpenKeyset, adLockOptimistic

It doesn't return any records. In Access it returns 43 records with the same SQL string. I tried taking out the * and then it returns only 1 record (416).
I'm using ado 2.1 with JET 4.0 on an Access 97 DB. (VB6 sp3)
PLEASE help me out here.. I need all 43 records returned.

Any queries on your database which use "LIKE" will need to use "%" as the wildcard instead of "*".








d. paulson

Are you sure your looking for a string??

That won't work if your not.

Hope This Helps,
->Noah