On Access Query window, I have executed one query with like operator ...like below:

SELECT EMPNAME FROM EMP WHERE EMPGROUP LIKE '*Lead*'

and it is suceesfully executed and returns 15 rows.

When i copy & paste the same code on my asp, it is neither giving error not returning any records. so i replaced * with % symbol like below:

SELECT EMPNAME FROM EMP WHERE EMPGROUP LIKE '%Lead%'

Now, the results are coming. I wonder, why this is required? what is the logic behind that? could anybody help me out?

BTW, i have used " DRIVER={Microsoft Access Driver (*.mdb)} " in my connection string.

Thanks in Advance.

Best Regards,
Saran.

__________________
Best Regards,
Saran.

If you use the Microsoft Jet interface with an OLE call, rather than ODBC, it should work OK.
-> http://www.connectionstrings.com/?carrier=access

I am a loud man with a very large hat. This means I am in charge