turn on debugging test and find out.

On Fri, 29 Mar 2002, Tony Schreiber wrote:

> While I know that like is always slower, consider this:
> 
> WHERE left(description,1) = 'A'
> 
> OR
> 
> WHERE description LIKE 'A%'
> 
> Which would be faster?
> 
> 
> Tony Schreiber, Senior Partner                  Man and Machine, Limited
> mailto:[EMAIL PROTECTED]                   http://www.technocraft.com
> 
> http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion
> http://www.is300.net ___________The Enthusiast's Home of the Lexus IS300
> http://www.digitacamera.com ______________DigitA Camera Scripts and Tips
> http://www.linklabexchange.com _____________Miata Link ECU Data Exchange
> 
> 
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
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

Reply via email to