Ok I know I have dealt with this once a long time ago but for the life of me I can't figure out where it was to look it up. I need to build a statement like this:<BR><BR>sql = "SELECT FirstName FROM tblNames WHERE FirstName Like '*tim*'"<BR>rst.open sql, cnn, 1, 1<BR><BR>The problem is when I do this it returns no records. This is via ODBC to an access db. If I take the EXACT same statement and paste it into a qry in access it works fine. What gives?