RE: Alphabetic List

Fri, 26 Jan 2001 15:48:03 -0800 

This is not as fast as:

WHERE lname LIKE 'A%'

when the "lname" column is indexed.

best,  paul

At 01:53 PM 1/26/01 -0500, you wrote:
>Or do a query and on the last name field
>do where lname = Lower(Left(LName, 1)) = 'letter'


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to