View Single Post
Old 2005-05-17, 07:28 PM   #2
cd34
a.k.a. Sparky
 
cd34's Avatar
 
Join Date: Sep 2004
Location: West Palm Beach, FL, USA
Posts: 2,396
if you know your starting letter and record it somewhere:

select if(sortletter<'$firstletter',ascii(sortletter)+100,ascii(sortletter)),title from links order by 1,title;
__________________
SnapReplay.com a different way to share photos - iPhone & Android
cd34 is offline   Reply With Quote