Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
paging in alphabetically order
- Thread starter lenelene
- Start date
Code:
SELECT LEFT(`nick`, 1) AS shortnam FROM yourtable GROUP BY shortnam ORDER BY shortnam ASC;ps. might be some typo here, but I guess you get the general idea of the SELECT LEFT(field or value, length) AS newfieldname...
Olav Alexander Mjelde
Admin & Webmaster
- Status