help me !

I have a table ( In mydatabase ) of customer files ( About 5.000.000 records )
I want to find name of customer
my query :" select cus_name from customer where cus_name like '%var%' "

but it's very slowly
hepl me !

( My PC : PII, 450Mhz, 128M ram, 4G HDD )

[Chris Eastwood]

>:" select cus_name from customer where cus_name like '%var%' "

Do you have an index on the 'cus_name' column in the customer table ?


Chris Eastwood

CodeGuru - the website for developers
http://codeguru.developer.com/vb