[snip] How can order by be forced to order alphabetically and ignore accents without stripping the accents for printout? This is a problem for both caps & normal letters. [/snip] Definitely an SQL question. What character set are you using in your database? Is the accent the first character of the string or is this a multi-byte character? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php