on 8/29/03 10:26 AM, Joshua Miller at [EMAIL PROTECTED] wrote: > SELECT DISTINCT(Left(your_column_name,1)) > FROM your_table_name > WHERE your_clause > > That should do it.
I've got to do that for 26 letters? It seems like I'd do a query, maybe try to group the output or order it by last name descending, then somehow loop over that. That *seems* like an awful lot of work. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
