What about mySQL? Do you know if this is documented and easy to find?
On Wed, Sep 8, 2010 at 1:23 PM, DURETTE, STEVEN J (ATTASIAIT) < sd1...@att.com> wrote: > > With SQL Server, DEFINITELY go with left(str, 4) = 'string' > > It has much less processing overhead. > > -----Original Message----- > From: Michael Grant [mailto:mgr...@modus.bz] > Sent: Wednesday, September 08, 2010 1:20 PM > To: cf-talk > Subject: WHERE Left(str,5) = 'string' VS WHERE str LIKE 'string%' > > > Any advantage to one over the other? > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336904 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm