Added: September/14/2006 at 8:33pm | IP Logged

I am just starting to learn this stuff.  Currently using an Access database with 2 fields- Quote, Author

When I run this query from asp I get an empty recordset:

strSQL="SELECT Quote, Author FROM quotes WHERE Author Like ""*proverb""; "

When run in Access it returns the data I am seeking.  The problem it seems is the * wildcard in the LIKE portion of the statement.  If I remove the * the query runs fine but not all the records show up.  This is why i am using the wildcard

Any info would be helpful.

adTHANKSvance,

Ken