What if you change out your query to look like this?

SELECT * FROM Note WHERE No_Code = "EZ" and No_Code = "25329" and No_Code = "REASON"

Mostly it breaks down the string and searches into smaller segments. My tests did show an improvement in time. Not amazingly faster - But faster nonetheless.

Tom Welch


>I have a table called NOTE that is used as a Memo field (this was before they >were created).

>It is indexed on NO_CODE and here is a Select I ran for it:

>SELECT * FROM Note WHERE No_Code = "EZ 25329REASON "

>This query takes around 1 minute to run, the table is 270MB in size and has >2.8 million records and the field length of NO_CODE is C15.