select whatever
from userdatabase
where
lastname like 'A%'
will give you everyone who's last name starts with 'A'.
Regards,
Thomas C.
Office: 01565 757 909
This space for rent
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 26 January 2001 16:14
> To: CF-Talk
> 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
