>>>>Hello All,
>>>> I've got 6000 records in our order database. We have 8 users on our windows 2000 server network. It can take as much as 20 seconds to do a search for last name in this data. Why so slow? I have an index on last name but am searching on Upper(lastname). Should I make the index upper(lastname) would this help?
>>>>
>>>>Thanks,
>>>>
>>>>Smyte
>>>
>>>Yes, index must match exactly the searched expression if you want rushmore to kick in.
>>
>>Or other way around :)
>
>Time to go to bed...! :-)

God natt