Not so. However,
SELECT People Info
WHERE LastName LIKE '%A%'
WILL cause a full table scan.
best, paul
At 11:35 AM 1/26/01 -0500, you wrote:
>I would recommend against using this method
>even if the field is indexed as this causes a
>full table scan to occur which will greatly
>degrade as it is used a lot and as the table
>grows in size.
>
>Jeremy Allen
>elliptIQ Inc.
>
> >-----Original Message-----
> >From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
> >Sent: Friday, January 26, 2001 12:27 PM
> >To: CF-Talk
> >Subject: Re: Alphabetic List
> >
> >
> >You can do this in your SQL
> >
> >SELECT People Info
> >WHERE LastName LIKE 'A%'
> >
> >This would be for people with last names that start with A.
> >
> >Kevin
> >----- Original Message -----
> >From: <[EMAIL PROTECTED]>
> >To: "CF-Talk" <[EMAIL PROTECTED]>
> >Sent: Friday, January 26, 2001 10:13 AM
> >Subject: Alphabetic List
> >
> >
> >> Hi,
> >>
> >> In Yahoo address book, they have this list for finding a particular
> >> person easily
> >> by the first letter of their last name:
> >>
> >> All - A B C D E F G H I J K L M N O P Q R S T U V W X Y Z - Lists
> >>
> >> Does anyone have any insights on how the algorithm of implementing this
> >> feature?
> >>
> >> For example, I have a user database, and I want to use this feature to
> >> find
> >> persons whose last name start with a particular letter.
> >>
> >> Thanks!
> >>
> >> Hong
> >>
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
