In a table called 'advisers' I have a column called 'surname' which contains the surnames of a number of people. Using a query like: 'select * from advisers order by surname' lists the people in the correct order but some people have surnames like 'du Sautoy' and 'van den Berg' and these are listed in the order of the first character that appears in their name, so that 'du Sautoy' appears surnames beginning with 'D' rather than 'S', etc.
Does anyone know of a way of getting ORDER BY to sort on uppercase elements only in a sort string, so that 'du' and 'van den' in the example above are effectively ignored? Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]