Problem with LIKE operator

[sebke]

Hi,

I have to search on a heavy table using LIKE operator. When i put the Select on the asp page using the LIKE operator, it starts searching until the time out is reached (about 2 minutes). If i put the same query directly on the access, it shows the correct result in about 2 sec. All variables are sting.

If some one knows what could be the difference using LIKE on MS access and a asp page please tell me.

Regards.

 

[MarkSweetland]

Could it be you're using an asterisk * (Access DAO) instead of a percent % (Using ADO in ASP?) in your SQL statement?

...WHERE strItem LIKE 'ABC%'