I have Access 2000 and VB6 using ADO to call stored procedures. All the procedures work with the exception of a particular stored procedure:

PARAMETERS [pbar_PK] Text ( 255 );
DELETE *
FROM tblFoo
WHERE bar_PK Like [pbar_PK];

PROBLEM:
When I run the stored procedure with 5.* in Access it finds the appropriate records and deletes them. When I call it from VB6 using 5.* it deletes no records.

I'm passing it in as a Variant/String. Other delete sps work. It seems to be a problem with the wildcard. All watches and locals show the parameter to be 5.*

Thanks for any suggestions.

-rufford