If 'Something%' is running ok, why not create another column that is the reverse of the current one, then reverse FORM.comapny_name and use the faster '#FORM.company_name#%'?
Does that even make sense? :OS Ade -----Original Message----- From: Russ 'Snake' Michaels [mailto:[EMAIL PROTECTED] Sent: 28 October 2003 15:31 To: [EMAIL PROTECTED] Subject: [ cf-dev ] VARCHAR searches I have a table in a BIG database where I need to search on a varchar field like this Select * from table Where company_name LIKE '%#form.company_name#%' But it is slow as hell. Every thing else is running at a decent speed, on direct comparisens and even if I do a LIKE '#form.company_name#%' it is fast enough. I have indexes and a ful-text catalog, ios there any other way to speed up such a query ? Russ -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
