If you mean because I was using a CF-looking function, that's only because I was to lazy to look up the string function in oracle. ;)
> 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
