wildcard in recordset filter

[formerTexan]

Hello,

Get someone suggest what I am missing in including wildcard characters in the filter for a DAO recordset

The following work:

CName Like 'A*'
CName Like 'A*A'
CName Like '*A*'

But this raises a syntax error:

CName Like '*A'

Substituting % for * brings the same results.

THanks,
Bill