The most likely problem is your LIKE wildcard.

Instead of
Code:
SELECT * FROM tblNAmes WHERE strFirstName LIKE '*a*' ORDER BY strFirstName;
try
Code:
SELECT * FROM tblNAmes WHERE strFirstName LIKE '%a%' ORDER BY strFirstName;
.

Hope that helps,

Ted
OpenLink Software
Technical Support