If you need to list them alphabetically then you should just retrieve them alphabetically from the database:
SELECT employee_lname FROM employees ORDER BY employee_lname If you're not getting the names from a dB, but have an actual list then you could convert the list to an array (using listToArray()), then sort the array using ArraySort() Or is there another reason why you need the first character? Bert On Mon, 15 Nov 2004 10:03:20 -0500, Robert Orlini <[EMAIL PROTECTED]> wrote: > I need to output a list of names alphabetically via the field > "employee_lname" (last name). > > What's the code that can check the first letter of the field employee_lname? > > Thanks. > > Robert O. > HWW > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184276 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
