I have tried using the like statement in DAO but it does not seem to work with the %
this seems to only open the recordsets that match the string exactly with the exception of the '%'. It will not pick up an event named 'EVENT01AA' for example. Is there a specific rule that must be followed for it to work.Code:strSql = _T("SELECT * FROM [TABLE01] WHERE [SME_PIN] = 'PIN01' AND [Event] LIKE 'EVENT01%'"); rs.Open(AFX_DAO_USE_DEFAULT_TYPE, strSql );