I'm using winxp pro - vb6 sp6 - jet40sp8 - mdac 2.8

The msaccess 2000 table contains this records :

code name Last Name
1 william Rodes
2 william Jones
3 robert riffel

if i applied this filter : data1.recordset.filter = "name like 'wil*' "
no records are returned
but if i apllied this one : "name like 'will*' " the 2 records were displayed

Any ideas ?

Charlie Root