re-sorting auto_increment fields

Hi ANy idea how i can get my auto_increment fields to renumber themselves after deletion of records so that they all get re-ordered and run consecutively from 1 to whatever without any numbers missing ? Please help if you know how to do this Thanks Keith White

Case Sensitivity Problem

Hi, Can somebody PLEASE help me If I send a query to get a list of names, like this: SELECT Name FROM users ORDER BY Name, I get a list of users like this... Bob Jon Mark Sally andy lucy mary steve when what I REALLY want is this... andy Bob Jon lucy Mark mary Sally Steve Can someone g