Do you want to do it in the DB or in CF? If in the query then it depends on the database you are using, something like this would work in Oracle
SELECT SUBSTR(EMPLOYEE_LNAME, 1, 1) AS ABBR FROM EMPLOYEES ORDER BY UPPER(EMPLOYEE_LNAME) If in CF then #Left(queryname.employee_lname, 1)# would output just the first one 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:184273 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
