<CFQUERY .......>
SELECT ID,LastName,Address,etc...
FROM Orgs
WHERE LastName LIKE '#alpha#%'
</CFQUERY>
where the value of alpha is one of the letters of the alphabet
best, paul
At 11:13 AM 1/26/01 -0500, you wrote:
>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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
