you can use a LIKE '#letter#%' or depending on your DB use a subscript function <[EMAIL PROTECTED]> 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
