Got to ask, Why wouldn't it return any records?
Jerry Johnson >>> [EMAIL PROTECTED] 03/29/02 11:59AM >>> 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 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
