On 3/29/02, Tony Schreiber penned: >While I know that like is always slower, consider this: > >WHERE left(description,1) = 'A' > >OR > >WHERE description LIKE 'A%' > >Which would be faster?
The first one would be faster. But only because it wouldn't return any records. ;) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
